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?

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

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

If you select fields with the same name from each table, the field names are qualified with the table name in the recordsource. So, you end up with something like:

FldA
FldB
Tbl1.FldC
Tbl2.FldC
FldD

This is most likely what is causing the problem. Change the query so that you assign unique names. To do that add some new name followied by a colon in the Field cell.

FldC1:FldC
Tbl1

FldC2:FldC
Tbl2

Then, your field list will look like:
FldA
FldB
FldC1
FldC2
FldD

Be sure to fix any bound fields so they reference the correct "new" field name.

Another possibility is a left over filter or order by property on the form.