Filtering Form Criteria and Searching Main Form

[gatorator]

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!

[alansidman]

Here is an alternative solution that you may try.

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

Alan

[gatorator]

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

[gatorator]

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