update VBA from query

[trevorC via AccessMonster.com]

Hi all,

Is it possible to update a vba code variable from a query called from the VBA
code.

EG
docmd.openquery "testquery" ' has one filed that returns a number
get returned value from query to use here
T = return from query

If so how do do this.

regards
Trevor