ComboBox question vb6

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

Quote:

---

Originally Posted by franki

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

---

Could you post the field names as well as some sample data?

That was quick!
I have posted the access2k database. it also has a form called products which is what i am trying to replicate in vb.
Many thanks.

Quote:

---

Originally Posted by franki

That was quick!
I have posted the access2k database. it also has a form called products which is what i am trying to replicate in vb.
Many thanks.

---

Check out the attached Project