Update query underlying a combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a form, I have a frame that is used to identify a building number (1,2,3)
the value of which is used as the select variable of a query underlying a
combox, the value of which is stored as part of the record completed by my
form.

However, the variables in the combobox do not switch to those associated
with another building after a building variable is identified for the first
time in frame and a value from the combobox is selected.

I've tried using a macro to refresh the page after changing the frame value
and tried SendKeys {f9} with no luck.

What am I missing?

Thanks - Ken
 
Ken,

Use a Requery action in your macro. Specify the name of the combobox in
the Control Name argument of the macro, like this...
[NameOfYourCombobox]
Assign the macro on the After Update event property of the building
number option group.
 
Back
Top