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

Using SELECT in Access 2000 and display returned data

P: 62
I am trying to display data using SELECT on "Form Open" to text boxes, but am failing! ie:

Data = "SELECT * FROM tblInvoice"

Combo1 = Combo1.RowSource = Data
Combo1 = Combo1.ItemData(0)
Text2 = Combo1

The only way I have found to show the results on a form is to use a Combo Box to receive the above query and then transfer it to a Text Box. (The above code may be slightly incorrect but is shown for illustration purpose only)

My question is: How do I get the data displayed in a text box without using a Combo Box
Mar 20 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,366
Set the recordsource of the form to that table. Then you can use bound textboxes.
Mar 20 '07 #2

P: 62
Thanks!! I knew it had to be something simple, I just couldn't work it out.
You guys are GOOD.

Thanks again
Mar 21 '07 #3

Expert Mod 10K+
P: 12,366
Not a problem, good luck.
Mar 21 '07 #4

Post your reply

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