Adding Items in Combo Box

[aileeny]

Hi! I have a problem using the combo box control.

I have an Access database with a table called Customers with existing records. How do I create a combo box in the VB form which will automatically look up the field called CompanyName from the table without me having to type the records into the List property one by one or use the AddItem method to add the items as I have over 200 records? Also, I do not want to allow the users to be able to add items to the combo box but allow them to look up the list once they key in a letter.

I would deeply appreciate it if anyone could help me out here. Thanks.

[Bigley]

Well if you stick the 'AddItem' inside a loop it wouldn't be all that bad would it?

[paulw]

Is the VB form part of a true VB application or is it an Access form? Access has some methods available that make what you want to do trivial. With VB you have to code round it.

Cheers,

P.

[Vit]

In order to provide read-only acess for users just set style of your combo to DropDown List. This will enable only selection of existing items