Query result to text field

[Gary McCarthy]

I have a query that returns a state value, e.g. TX.

I need for that result to populate a text field on a form for comparison.
The query is not based on the record source for the form.

My attempts gives an error -

Me.SAP-ST = Query!qrySAP00Code!ST

Any help is appreciated.

Thanks.

 

[Jeff Boyce]

Gary

One approach might be to use the DLookup() command, point it at the query &
that specific field in the query.

So your code would look more like (untested, incomplete):

Me!SAP-ST = DLookup(...)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP