Linking Combobox to Form and Updating

[kevygee]

I have a combobox that displays information about a current record on a form (much like a subform would show all information related to a certain record). So for example, there is a user and the combobox would list all the users applications. Now, when the record is changed (via the navigation buttons) I want the combobox to requery, but I don't know where the query should go. I tried putting the requery under the primary key's afterupdate method, but no go.

Can anyone think of a solution? Do you understand my problem?

Thanks in advance.

 

[quest4]

In the combo boxes GotFocus event put:
Me.MyComboBoxName.Requery
Make the name substitution and that should do it. hth.

 

[kevygee]

Great! Thanks a ton, works perfectly. Didn't even think about GotFocus. Seems like that might always be a good way to do it, because that way, when someone accesses the list, you can be assured that the contents of the combobox are up to date.

 

[quest4]

It is the best way, but I did see one where it had to be in another event, but it had to waite for a couple of functions to finish before doing the requery. Ohwell, glad I could help.