Hi all...
I have been struggling to get a text box to display the correct concatenated string of data
Form Fields:
SO_ID - for my job number from my SO_Main table
Customer - Customer Name from my customer table
Purchase Order - PO number.
I have concatenated these fields in my SO_Main query and i get the result
When i add the text box and add the link to my query field as the control data source I get #Name?
What am I doing wrong?
Thank you
I have been struggling to get a text box to display the correct concatenated string of data
Form Fields:
SO_ID - for my job number from my SO_Main table
Customer - Customer Name from my customer table
Purchase Order - PO number.
I have concatenated these fields in my SO_Main query and i get the result
When i add the text box and add the link to my query field as the control data source I get #Name?
What am I doing wrong?
Thank you