form bound to query, display concatenated fields

[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

 

[Dirk Goldgar]

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.

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.