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.
-----Original Message-----
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
