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.