Show calculated query field into text control on form?

[Newbie2012]

Show calculated query field into text control on form?

I have a query which has a new calculated field to concatenate different fields from the tables because I want to create a document code.

I would like this code field to show on a form from the same main table (which has most of the fields in it, being concatenated)

I keep getting the error? or #name

I also need this calculated field to be searchable in the form

Can this be done and if so, could someone please advise

 

[MStef]

Try to do this with DLOOKUP function.