Filtering a subform using a search form

T

Tony

Hi Group

I have extended a general search form provided on Dev Ashish's Access site to allows users to filter a main input form based on the results of a performed search. It works well but I would like to extend this search routine further to allow users to filter fields on subforms, which also appear on the main input form. (As the fields on the subform are linked to the main form they should filter the main form as well)

In extending this routine I have added the subform fields to my main search query. The problem occurs when I try to return to my main form as Access asks me to 'Enter Parameter Value'. Is there a way around this?

Here is the working code for filtering fields on the main form. (strGlobalSQLWhere is the product of a dynamic SQL routine that is produced and captured by the search form)

Any help would be grateful

Tony

'VBA Cod
'Open up and filter main by using Where claus
Dim stDocName As Strin
stDocName = "frmMainForm
DoCmd.OpenForm stDocName, , , strGlobalSQLWhere
 

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

Populate main form from subform record 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Trying to Open subform on click event to current record from main form 2
Filtering subforms via main form 2
filtering a form based on the values of a subform 0
Open form and filter form & subform using combo-boxes 2
Search Form with a SubForm 3
Subform filter is inherited? 3

Top