Update Dropbox listing...

  • Thread starter Thread starter Fox Freejack
  • Start date Start date
F

Fox Freejack

Hi,

In a Form and Form Detail Windows, I have a Dropdown List that is
modified according to a Value in the main form.

The DropList is an output of a query that reads the value in the main
form for filtering. This works...

But it only runs the Query Once at Form Load and never update it as I
change the record in the main Form.

Thanks for any help

David
 
The main form's OnCurrent event will run every time you change records in
the main form. In this event, requery the combo box.

Me.sfmNameOfSubformControl.Form.cboCombobox.Requery

The sfmNameOfSubformControl is the name of the control on the main form that
holds the subform, not the name of the subform itself.
 
Back
Top