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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
First Subform record gets modified when closing form 3
filtering a form based on the values of a subform 0
Sub Sub Form Query Will not wait for main form to be populated. 1
adding new data into existing fields? 0
How to make a sum of a sub-form on the main form 2
default values in drop list mystery 1
Help With MS Access 4

Back
Top