ComboBox question vb6

[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

[Mark Gambo]

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?

[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.

[Mark Gambo]

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