ACC1x: How to Requery a Combo Box on Subform

ID: 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: <Subform ControlName>
   2. GotoControl
         ControlName: <ComboBox ControlName>
   3. Requery
         ControlName: <ComboBox 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.

REFERENCES

For more information on form events, search for "events" then "events for forms" using the Microsoft Access Help menu.

Additional query words: macros forms

Keywords : kbusage FmsEvnt
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbhowto