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

Main Form and two Subforms 2
First Subform record gets modified when closing form 3
Combo box to search on a field in the subform 1
Find button on main form that searches a subform. 1
Find Record in Subform 1
Access Daily Entry with multiple entries per field 0
VBA Syntax for subform record source change 6
Subform 7

Back
Top