Displaying a Query result in a text box

[amc1902]

Hello all,

I'm new to the world of access but learning a little more each day!

I have a command button (Case received within period) that runs a query (qrydaterec) without any problem and displays it in a data field view. What I woud like is to display the result in a text box (textbox 68) which sits alongside the command button which runs the query.



I've searched the forum and it seems that the =DLookUp ("Field name","Query name") could be what I'm looking for. The only issue is, I'm not sure where this command would be placed. Could anyone advise? Alternatively, would there be an alternative available that could achieve this result?


Many thanks

[ranman256]

If you want to update 1 text box then on the button _Onclick event:

txtBox =DLookUp ("[Field name]","qryDaterec")

[amc1902]

Hi, many thanks for your reply. The _Onclick event for the button launches the query therefore it is already populated. Am I able to add your command to this, in effect having two commands for the _Onclick event?

[ranman256]

you can plug in as many cmds or vb code in the SUB BTN_ONCLICK() event as you want.

[June7]

What do you mean by 'launches the query'? A SELECT query doesn't need to be 'run' or 'launched' - just reference the query in the DLookup or open form or report bound to the query.

Unless the query has dynamic parameters - that could complicate. I never use dynamic parameters in query.