Requery Query

[Guest]

I have a combo box that has a query as a rowsource. It seems that when I
update the table that forms the query, the combo box doesn't display the
updated information even when I perform a combo box requery. Is it because
the query as the rowsource is not being updated? Is there a requery command
for a query as well? Thanks.
ck

 

[Guest]

Please ignore this question as it is working now. Thanks.
ck

 

[Van T. Dinh]

There may be timing problem that can re-surface later. For example, if you
update the Table, the update may still be in the cache and yet to be updated
into the Table. If you do the Query at this time, your ComboBox may not
pick up the updated data.

Use the Idle Method to make sure the data is updated into the Table before
Requery.