Update Dropbox listing...

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
 
W

Wayne Morgan

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

QBF & Query Malfunction 0
filtering a form based on the values of a subform 0
Updates for excel 2002/3 0
How to Update a form: requery, recalc, refresh from subform entry 5
Filter on Subform Not Displaying as Expected 1
How can I update the data listed in the combo box to show the most 1
Using DSUM to get running total on a filtered form 0
Form doesn't move to next record after update 3

Top