Hi All,
I am really struggling getting a combox to work.
I am using an access2k database basically with 2 tables. Products and Location. The products table has a location id field (number) and the Location field has a location id field(number) with a location description field(text).I am using ado code to link to the database.
Ok..I have a form showing all the product records but I want to be able to have a combo box on the form that lets me choose a location ie shows all the available locations from the location table and saves the choice to the Products table in the location id field.

This is a 1 minute job in access2k but how do I do it in VB6???????
Hope some wiz can give me the answer.
Thanks