Combo Box Filter subform

R

Rhett_Y

Hello..

I have looked and searched but still can't find what I am looking to do.

I have a form with a subform: frmMainData and frmSubComponent. Each form is
based off a different query: frmMainData = qryLocationPhase and
frmSubComponent = qryComponent

I have a one to many relationship setup for the tables the queries are based
off. IE one location many components.

On the form I have a drop down boxes cboUOA.

What I would like to do is have the cboUOA requery the subform so that the
location is entered and everything assigned to that location shows up in the
subform. I have tried a different requeres and I have not been able to get it
work.

I have a copy of the database that I can send if need be.
 

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

Automation of scanned file storage based on content 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Subform issues with combo box 8
dynamic combo box on subform- show full list Box on main form 9
requery subform combo afterupdate of main form combo 5
main form/subform 1
lookup then set a filter 0
subform filters 3

Top