Searching subform fields ?

  • Thread starter Thread starter Citizen
  • Start date Start date
C

Citizen

Someone is asking me advice on how to look for a parameter that is a
field in the subform of a main form.
The main form has a table as source, so does the subform.

The main form has a standard access search button and this person
wants to search on a subform field with a certain value throughout the
whole recordset. But no hits are found, because this search button
only searches the main form. When we use a filter on the field in the
subform only the current record from the main form is searched.

What options are there to search troughout the whole subrecordset
also?
 
Hi Citizen,

Design a query that has both the subform field and main form field in it.
When the user clicks the search button in the main form, use DAO or ADO to
locate the subform field in this other query, then use the corresponding main
form field value to find the record on the main form.

Cheers,
Murp
 
Back
Top