Thread: Filtering Form Criteria and Searching Main Form

I have a search form (well a criteria based form) which is launched from my main form.

The search form contains drop down values based on the values in tables. When a user selects on of these values from the dropdown the after_update event kicks in, the main form returns the recordset for the criteria chosen and the search form closes.

I have seen this in action and know it works however I am having trouble with the code and it is throwing up errors

Forms!("Form Name").RecordSource = "Select * from [Table] where [Table].[Field Name] like """ & Me!FieldName

The field I am using contains unique values, the query is looking across two tables but they are joined and give me no trouble anywhere else.

Any help would be appreciated!

Originally Posted by alansidman

Here is an alternative solution that you may try.

http://www.datapigtechnologies.com/f...tomfilter.html

Alan

From the looks of it that may be ideal, I just need to get a set of headphones!!!

Il let you know how I get on, thanks for the reply

Originally Posted by alansidman

Here is an alternative solution that you may try.

http://www.datapigtechnologies.com/f...tomfilter.html

Alan

That did the job, fantastic! thanks for your help