[AccessD] return query result in variable?

Hi,

how can i return the result of a query into a
variable?

I've done it before (2 years ago...) but I cannot seem
to get the syntax correct.

I've tried stuff like this:
Dim intNewPrjctID as Integer
intNewPrjctID = Docmd.Runquery "qryNewPrjctID"
txtPrjctID = intNewPrjctID

Any ideas?

Sander

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com