C
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
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