I have two combo boxes, I need the second to only display options with the same Z field as the item selected in the first combo box. How can I do this?
Thanks for your help.
I have two combo boxes, I need the second to only display options with the same Z field as the item selected in the first combo box. How can I do this?
Thanks for your help.
You could use the after update event for the 1st combo and then change the record source for the 2nd combo. Of course you would also need to change it back once you use the 2nd combo.
HTH
Thanks, that kind of helps. I am really new the access, im somewhat familiar with programming little things like Java applets and VB for minor excel projects. However, I am not sure how to format the row source such that it only shows the intended (matching) options based on the Z field.
Example: Using the AfterUpdateEvent for cboCombo
HTH
If Me.cboCombo0.Value = "something" Then
Me.cboCombo1 = "something"
End If
Ok, I think that'll get me where I'm going. Thanks.