Looking up related tables in combo boxes

[toon10]

Hi

I have a VB 6 form which sits on top of a part table in Access. The form allows the user to select a part from a combo box. They can also add, delete and edit parts on the database.

All is fine except that when a new part is entered, the part table takes a ProductID field which is linked to a Product table. For example, on the part table, part XX1234 might have a ProductID of 3, which relates to a specific product on the product table. What I want to do is when adding a part, instead of having to type in “3” and expecting the user to know what product that is, I want to a combo box to lookup the description from the matching product table instead. Obviously, when the record is saved, the productID is saved to the part table.

I hope I’m making sense!

Cheers

 

[muraliambt]

Hi,

U can use Databound combobox.

with combobox
.recordsource = tblname
.listfield = product description
.boundfield = product ID
end with

Muraliambt.