Referencing a Combo Box


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??????


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
Ryan ChongCommented:


typo in question or in your code?

shouldn't it be as Column?
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAuthor Commented:
Yes correct typo error
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.