Microsoft KB Archive/101082

{|
 * width="100%"|

ACC1x: How to Requery a Combo Box on Subform

 * }

Q101082

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1
 * Microsoft Access Distribution Kit, version 1.1

-

SUMMARY
This article describes a macro that will requery a combo box control on a subform. This macro is useful for a combo box that is based on a query that references the main form and thus should be requeried whenever you change records on the main form.

MORE INFORMATION
The following sample macro will requery the combo box:

  Macro Name     Action          Defined Below RequeryCombo  GoToControl     1 GotoControl    2 Requery        3

RequeryCombo Actions -  1. GotoControl ControlName:  2. GotoControl ControlName:  3. Requery ControlName:  When this macro is run, it will requery the combo box. If you want the combo box to be requeried each time you change records in the main form, add this macro to the OnCurrent property of the main form.