Hello
This is my first posting...and the next will be my second ...lol
I need to show the entire contents of a field in an access table, so that you can choose one item. i can then input data for the other equations. this is for a project and the vb form is an invoice. I can create the links but scrolling the data box is the only way i can get the value in the drop down box to change
Help please :sad:
If you are using bound controls, if I was you don't!! they work for millions of people but you do not have full control, and you learn nothing.
To add to a dropdown list.
Dim db As Database
Set db = opendatabase("c:\mydatabase\mydb.mdb")
Set mRs = db.openRecordset("select myField from myTable order by myField")
Do While Not mRs.EOF
Combo1.AddItem mRs("myField").Value
mRs.movenext
Loop
obviously do not open a database connection everytime. :)
PS don't forget to add the microsoft DAO object library first in the project references.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.