form bound to query, display concatenated fields

K

Ketaki

Hi,

I have an MS Access form bound to a query. in a text box i
want to display concatenation of 2 fields from that query.
it is giving me a #Name? error but can display individual
fields by themselves. I tried both & and + signs, but does
not help.

Thanks,
Ketaki
 
D

Dirk Goldgar

Ketaki said:
Hi,

I have an MS Access form bound to a query. in a text box i
want to display concatenation of 2 fields from that query.
it is giving me a #Name? error but can display individual
fields by themselves. I tried both & and + signs, but does
not help.
Click to expand...

If your text box started life as a control bound to one of the fields,
it may have the same name as the field. Change its name to something
else that is not the name of any field in the form's recordsource.
 
Top