I have an Access ADP (connecting to MS SQL2000) form that has a tab on it and on one of the tabs is a sub form.

The subform open OK on its own, but when I open the main form I get:

The column prefix 'T_PO_Detail' does not match with a table name or alias name used in the query"

I have looked everyplace that I think T_PO_Detail would be needed and can't find any that would relate to the sub form.

__________________
Mitch

On your subform properties check and make sure the source of t_po_detail is correct. If it is based on a query check the query source is correct. A name record source may have occurred and was not changed in the query. If the main form property is based on a query make sure the tables or views, (all source) are spell or referenced correctly.

I did some testing and found that if I made the subform point to the table, it did not create the error, but if I set it to an sql statement then I get the error. The sql statement works on its own, so that is correct, but ot when I put it in the subfrom it cuses the error ONLY if I specify the "link child and master fields"

If I replaced the sql string with an actual view, then it worked without errors.

I don't know if this is a "binding" issue or what, but that worked.