VB6, Access97

I have a database of parts and one of the fields is Status.

How would I go about displaying that list on one form with a combo box to change the status(eg from ‘In Stock’ to ‘Sold’).

I want the combo box to be populated from another table.

So it’s basically a two column table with the second column’s cells being combo boxes.

Or is it only possible to have a transport control on the bottom and only have one part displayed at a time?

Any idea’s would be appreciated, Thanks

Craig