There are more than one table with identical field names. Access needs to know which one to use.
You need to specify the Table name.

[TableName].[FieldName]

Thanks for the quick reply. I looked at the SQL in OrderInvoiceQ and it appears to be OK. Or am I looking in the wrong place. Not an Access expert.

Can you share your SQL?

SELECT OrderT.*, [FirstName] & " " & [LastName] AS CustomerFN, OrderDetailQ.ProductName, OrderDetailQ.Quantity, OrderDetailQ.UnitPrice, OrderDetailQ.Notes, OrderDetailQ.ExtPrice, CustomerT.FirstName, CustomerT.LastName, CustomerT.Contact, CustomerT.Address, CustomerT.State, CustomerT.Zip, CustomerT.County, CustomerT.Phone, CustomerT.Email, OrderDetailQ.InvTotal, OrderDetailQ.PmtTotal
FROM (OrderT LEFT JOIN OrderDetailQ ON OrderT.OrderID = OrderDetailQ.OrderID) LEFT JOIN CustomerT ON OrderT.CustomerID = CustomerT.CustomerID
WHERE (((OrderT.OrderID)=[Forms]![OrderF]![OrderID]));

It is probably CustomerFN.
Try this:

[CustomerT].[FirstName] & " " & [CustomerT].[LastName] AS CustomerFN

I should edit the SQL to: SELECT [CustomerT] . [FirstName] & " " & [CustomerT] . [LastName] AS CustomerFN

I incorporated Kevin's suggestion and fixed the ().

Make a copy of your Query (for backup), then try pasting this into your SQL:

SELECT OrderT.*,
OrderDetailQ.ProductName,
OrderDetailQ.Quantity,
OrderDetailQ.UnitPrice,
OrderDetailQ.Notes,
OrderDetailQ.ExtPrice,
CustomerT.FirstName,
CustomerT.LastName,
[CustomerT].[FirstName] & " " & [CustomerT].[LastName] AS CustomerFN,
CustomerT.Contact,
CustomerT.Address,
CustomerT.State,
CustomerT.Zip,
CustomerT.County,
CustomerT.Phone,
CustomerT.Email,
OrderDetailQ.InvTotal,
OrderDetailQ.PmtTotal
FROM OrderT

LEFT JOIN OrderDetailQ ON OrderT.OrderID = OrderDetailQ.OrderID
LEFT JOIN CustomerT ON OrderT.CustomerID = CustomerT.CustomerID

WHERE OrderT.OrderID=[Forms]![OrderF]![OrderID];


I would also typically not use * in queries like this.  I would list out all the fields to prevent these kinds of errors.

-Raymond

Raymond With OrderT.*, Access knows the fields are from OrderT because the Table is specified.

Kevin

I understand that.  I'm just saying I've run into issues in the past using * once I start using Join Queries.  It will probably work in this case, but there are times it causes issues.  I don't understand why, but I've seen it multiple times.

-Raymond

OK, tried it, but now have a syntax error. Also, did some other stuff, but to no avail. What is confusing is I've been using this invoicing program for the last couple of years. No problems. Then this happened. I can access the job invoice, but when I click on the Print Review to see the report is when I get the error. All your help is greatly appreciated.

Error solved, Deleted the alias field CustomerFN from the orderinvoiceQ. Made the appropriate changes to the OrderInvoiceR.
SELECT OrderT.*, CustomerT.FirstName, CustomerT.LastName, CustomerT.Address, CustomerT.City, CustomerT.State, CustomerT.Zip, CustomerT.County, OrderDetailQ.ProductName, OrderDetailQ.Quantity, OrderDetailQ.UnitPrice, OrderDetailQ.Notes, OrderDetailQ.ExtPrice, CustomerT.Contact, CustomerT.Phone, CustomerT.Email, OrderDetailQ.InvTotal, OrderDetailQ.PmtTotal
FROM (OrderT LEFT JOIN CustomerT ON OrderT.CustomerID = CustomerT.CustomerID) LEFT JOIN OrderDetailQ ON OrderT.OrderID = OrderDetailQ.OrderID
WHERE (((OrderT.OrderID)=[Forms]![OrderF]![OrderID]));
Thanks to everyone.