471,356 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,356 software developers and data experts.

Using SELECT in Access 2000 and display returned data

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
3 1312
Rabbit
12,516 Expert Mod 8TB
Set the recordsource of the form to that table. Then you can use bound textboxes.
Mar 20 '07 #2
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
Rabbit
12,516 Expert Mod 8TB
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.

Similar topics

5 posts views Thread by Keith W. McCammon | last post: by
4 posts views Thread by Japhy | last post: by
3 posts views Thread by Random Person | last post: by
12 posts views Thread by Steve Elliott | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.