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.

DLookup's probably the easiest

Thanks for the help!:)