PDA

Click to See Complete Forum and Search --> : Combo Boxes


icemanmt78
May 22nd, 2000, 10:21 PM
Can anyone tell me how to use a combo box with an access database.

Presently I have the data from a table showing in a text box. I want to show this data in a combo box ( The field entry which will show in this box has only six possible entries).

I would also like to use this box to select one of the possible entries when entering a new record.

Any ideas?

Mark

pardede
May 23rd, 2000, 09:04 AM
Just find a combobox on your toolbar, put it on your form and set the datasource property to your data control. Use a query to fill the list.

If you use lookup a table, use the DBcombo variant, this lets you specify the ListSource property which should point to a data control looking at your lookup table.