When click a combo box, I want to refresh the combo box's list, how to achieve this?

[Martin]

In a form, I establish a combo box. The combo box's list is originated from
a field of a table.

My question is: I want to refresh the combo box's list, every time, when I
click the mouse on the pushdown button of the combo box.

How should I do ?

Thanks!

Martin

 

[Larry Linson]

In a form, I establish a combo box. The combo box's list is originated
from a field of a table.

My question is: I want to refresh the combo box's list, every time, when
I click the mouse on the pushdown button of the combo box.

How should I do ?

There is no "drop down" event that fires when you drop down the list. You
can requery on occurrence of events that do occur as follows:

For a Combo Box named cboSelectIt, in the Enter and in the Click event of
the Combo Box, put the following:

Me!cboSelectIt.Requery

That should cover most situations where you'd need to requery -- when you
first enter the Combo or when you Click to choose a new "whatever".

Unless, however, some asychronous process or another user is updating the
contents of the Row Source, that may be overkill.

Larry Linson
Microsoft Access MVP