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
 
Back
Top