Return value from a query

[dealwi8me]

Hello,

Is it possible to return a value from a query in VBA, something like the following?

codeNumber=DoCmd.OpenQuery ("qryGetCodeNumber")

Thank you in advance.

 

[Rich]

DLookup's probably the easiest

 

[dealwi8me]

Thanks for the help!