#Type! error in form control

[Ashe]

Does anyone know what the #Type! error is referencing? I haven't found much on the forum about this error.

I'm trying to use an expression in a text box, but it's putting the error "#Type!" in the text box. Both parts of the expression are in the form's data source (which is a query).

The expression in the text box is:
=[PROJECT_NAME] & " (" & [DATE_START] & ")"

The same error is produced even with this expression:
=[PROJECT_NAME][DATE_START]

Thanks in advance!

[boblarson]

Did you put it in the CONTROL SOURCE of the text box or accidentally in another property?

[Ashe]

As it turns out, the name of the textbox was also the name of the data source (an old legacy form that was not conventionally organized, both were named "PROJECT_NAME").

I guess I should've taken the time to clean up the old form before trying to work with it...