Referencing a Combo Box

Hi

How best to reference a combo box (CboGrn) from the parent form while in the sub form , I have tried this code below:

If (Me.CboGrn) <> Me.Parent!CboGrn.Clumn(1) Then
MsgBox " Please Check the selection is wrong try again"
Cancel = True
Exit Sub
End If
End Sub
I want to get the column 1 of the parent combo box , the code is on the form before update event, could it be this part Me.Parent!CboGrn.Clumn(1) is not correct. The error here is Me.Parent!CboGrn.Clumn(1) data part not found.

Are there any issues here to fix here??????

Regards

Chris
LVL 2
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?
 
Pawan KumarDatabase ExpertCommented:
Ryan is correct.

Please try like this -

If (Me.CboGrn) <> Me.Parent!CboGrn.Column(1) Then

Combox box has a column property and inside that you can pass the index...

refer for more
https://msdn.microsoft.com/en-us/vba/access-vba/articles/combobox-column-property-access
0
 
Ryan ChongCommented:
Clumn

??

typo in question or in your code?

shouldn't it be as Column?
0
 
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Yes correct typo error
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.