problems with combobox Requery

[robert_anisoiu]

Hello,

I have a form with 4 comboboxes, each of them based on a query from a table, so, queries from 4 tables.

If the user does not find the information on the combobox, he push a button and the corresponding form opens. He enter the data, close the form and returns to the form where is the combobox.

For a single combobox the data requery work. But if I enter in each form corresponding to the table on which the comboboxes are bounded, only the first time the Requery is executed. I have Requery for the 4 comboboxes on form.GotFocus and on each combobox.Enter.

Can you tell me why the requery is executed just one time and no each time when I come back in the form from another form?

I work in Access 2007.

Thank you,
Robert

 

[Poppa Smurf]

Do your requery in the Got Focus event of each combo box and not the Enter Event of each combo box or form.

 

[robert_anisoiu]

Do your requery in the Got Focus event of each combo box and not the Enter Event of each combo box or form.

I already did that before sending the message. The same result.