By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

How to forward query result to a variable

P: 1
Hi i'm a newbie...

Just wanna ask how forward the result of a query into a variable or to the value of a textbox?

considering i have a query - "Select UserID from tblUsers where LastName = 'Chan' "

thnx in advance
Dec 6 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,382
Depending on how you want to use it you can store the results of a query in a recordset variable or you can use the DLookup() function.
Dec 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.