copy to a text box in a report

[109bow]

I am a novice to MS Access and not familiar with VB, so is it possible to copy and paste a value in a cell in a query to a text box in a report? I have managed to create a macro that goes to the value I require in the query but haven't found a way of for a better word "pasting" it into a text box in the report. Please see attachment
Thanks in advance

 

[pbaldy]

I'm kind of guessing at the goal, but a DLookup() would be one way to grab a value from a query and display it on a report:

http://www.mvps.org/access/general/gen0018.htm

That of course assumes that the report isn't based on the query.

 

[109bow]

The DLookup() seems it may work, but how do I select axle position 4 from the query 09ts data by even130. I have =DLookUp([09ts data by even110-1 last turn],[serial number]=4) but this returns #Name? in the text box in the report

 

[pbaldy]

The quotes around all the arguments shown in the link are required. It also looks like you missed the field argument.

 

[109bow]

Paul,
Thanks for your help, found DFirst was what I needed, =DFirst(" [110-1]![axle serial] ","[110-1]") worked just fine

 

[pbaldy]

Happy to help, though without a criteria I don't see how it can be returning the correct record.