Unanswered: search main form using the values in the subform
I am trying to fetch the values in the main form using the values that are selected in the subform using the combo boxes. In the subform there are three combo boxes. I am already able to search anything in the main form using a free text box field.
What exactly i want to achieve is:-
1). I want to have three combo boxes on the expertlist page and i want to filter the records using the 3 drop downs and once the data is filtered then use the free text box field and and again filter out the records.
I am attaching the database file as an attachment. Please help me with this.