In the dynamic Combo’s how would you select the first value to populate the combo Box I was trying this code, which Goes to the second Combo shows the dropdown,\. How do you get it to put the value of the first item into the combo Box.
Here is what I have
Private Sub BlackmanLocationCombo_AfterUpdate() LocationManagerCombo.Requery DoCmd.GoToControl "LocationManagerCombo" LocationManagerCombo.Value = "" LocationManagerCombo.Dropdown End Sub
Thanks Stephen
Reply from Richard Rost:
To set the value you could just say:
Combo1 = SomeValueID Combo1_AfterUpdate
That would set the value in Combo1 and force it to run its update event, which should requery Combo2 for you.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 307.