Link Child and Master Fields

  • Thread starter Thread starter Pradeep
  • Start date Start date
P

Pradeep

Hi,

I have 2 Comboboxes and a subform. I want to display the data based on
the values in EITHER OF the comboboxes, i.e if the user selects Combo1
then the values in the subform will display all values with its
col1=Combo1. If the user selects Combo2 then the values in the subform
will display all values with its col2=Combo2, and if he selects both
then the subform should display data with combination of both.


how can i do this
 
Have the subform based on a query that uses a hidden text box on the main
form as a parameter. On the AfterUpdate of each combo box, set the value of
a hidden text box and call the re-query
 
You must log in or register to reply here.

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

Requery Form from Combo Box 3
Combo Boxes & Requery Issues 2
Running a query and setting that value base on another combo box 3
AfterUpdate 3
List box not displaying data 8
Combo Box feeding other combo boxes 1
Selecting columns from a query by using a form 20
Link Child/Master Fields from Three Combo Boxes in Subform 2

Back
Top