Problem with multiple sources on a form

[FlashG]

I changed the source for my form to an sql statement to include some fields from a query, but now many of my searches and my subform get an error stating:

"The specified field 'Blah.[Blah]' could refer to more then one table listed in the FROM clause of your SQL statement"

how do I fix these?

 

[David R]

Can you change the source to the query itself, and just pass all of the fields from the table intact into your query?

David R

 

[FlashG]

OK I did that, put all the fields into one query but it still gives the exact same message... Any Ideas?