I am trying to concatenate the first and last name fields into a
report.

For the Control Source in the properties box for the text box
"FullName" I put the following:

=[First_Name] & " " & [Last_Name]

If the Record Source for the report is a table existing in the current
database, the full name appears correctly in the report preview.

IF I make the Record Source a linked table in the current databse, I
get #Error in the report preview.

I tried using the query builder and it puts this info in it (the
"FormsData" is a linked table in the current databsae)

=[FormsData]!First_Name & " " & [FormsData]!Last_Name
but I still get #Error.

Any idea why I cannot use the concat feature with linked tables?

Both tables are identical, except for location. The linked table is
the one I will be using as it is a daily export of  SQL Server data
and shared on a network.

Thanks in advance

Deb