filter list box with a combo box

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

Gary Hull

I have a form with a combo Box in the main form that selects a record

In the sub form I have a list box that selects a record on the sub form

What I need to do is to have the list box to be filtered according what is

selected with the combo box on the main form
 
In the AfterUpdate event of the combo on the main form requery the list box:

Me.SubformControlName.Form.Requery

Set the criteria of the list box to:

[Forms]![MainFormName]![ComboBoxName]
 

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

Need combo box to refresh when moving to new record 2017 1
Refreshing a subform 2
Filter form using multiple combo boxes selection 6
Requerying combo box in sub sub form 6
Using a Combo Box for Filtering a Continous Form 1
Combo Box to select a record and populate fields in a form 2
Combo Box help 0
Formatting combo box drop-down list 1

Back
Top