Requery Combo Box Source Per Record

[Casey]

How would I refer to the requery of the query I am
using as the source for a combo box? I tried using
Requery in a macro without referring to any control, for
the OnFocus property of the combo box itself.

Can I refer to the query itself, and if so how do I
refer to the query in my macro criteria box at the bottom
of the design view of the macro? Do I refer to it as
query.queryname or should I just use the query name itself.

I need to get this to requery itself as I go to each
new record. The main form of each record holds controls
that I am using in the criteria of the source query for
the sub form of that main form, and I want the information
in those controls to show in my choices in the combo box
using that query as a source.

I tried to post this earlier, but the person who
answered my question told me to place a requery action in
the afterupdate of the main form controls, which would not
be sufficient for what I want to do because it would
require an update by the user of the controls, which
should not have to be. I want the requery action to
happen either going from main form record to record, or
upon focus of the combo box which is using the query as a
source.

If you have some real knowledge of requerying
successfully, please let me know your advice for the
situation.

Thanks, and have a good evening.

Casey

 

[Roger Carlson]

Try the OnCurrent Event rather than AfterUpdate.