G
Guest
I have combo boxes that are populated from queries. I want them to refresh when I open the form. The way they are now, whatever I selected in my combo box before is now the default value
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Janet Russell
One way to do this is to create a macro with the command
Requery. In the macro design view, type in the name of
the control you want to refresh near the bottom of the
screen where it asks for the control name.
Next, go to design view for your form. Right click the
combo box and select properties. Scroll down until you
see "On Got focus". Click in that box and, using the down
arrow, select the macro you just created.
are now, whatever I selected in my combo box before is now
the default value
Requery. In the macro design view, type in the name of
the control you want to refresh near the bottom of the
screen where it asks for the control name.
Next, go to design view for your form. Right click the
combo box and select properties. Scroll down until you
see "On Got focus". Click in that box and, using the down
arrow, select the macro you just created.
want them to refresh when I open the form. The way they-----Original Message-----
I have combo boxes that are populated from queries. I
are now, whatever I selected in my combo box before is now
the default value
J
Janet Russell
One way to do this is to create a macro with the command
Requery. In the macro design view, type in the name of
the control you want to refresh near the bottom of the
screen where it asks for the control name.
Next, go to design view for your form. Right click the
combo box and select properties. Scroll down until you
see "On Got focus". Click in that box and, using the down
arrow, select the macro you just created.
are now, whatever I selected in my combo box before is now
the default value
Requery. In the macro design view, type in the name of
the control you want to refresh near the bottom of the
screen where it asks for the control name.
Next, go to design view for your form. Right click the
combo box and select properties. Scroll down until you
see "On Got focus". Click in that box and, using the down
arrow, select the macro you just created.
want them to refresh when I open the form. The way they-----Original Message-----
I have combo boxes that are populated from queries. I
are now, whatever I selected in my combo box before is now
the default value