Selecting between two combo box for same record

[GregShah]

I have a database to track materials going to a subcontractor and also to the end customer. I use two separate forms to track this data with the only difference being the combo box I use to restrict the name of the pieces shipping. I have a form that uses one combo box of items that have not yet shipped to the subcontractor. The other form is exactly the same except the combo box has all of the parts that have not shipped to the customer listed. I even keep this data in the same table.

Is there a fairly simply method that I can employ that, based on the shipment type, "subcontractor" or "customer", the proper combo box can be selected?



Thanks for any help,

Greg Shah

[June7]

The comboboxes are bound to the same field?

I would use one form and have code that sets the combobox RowSource.

[GregShah]

Currently, I use two queries to track the quantity and name of the parts that need to go to the sub and then to shipping. As long as the quantity is greater than zero, the name of the part appears on the combo list. So the two forms are basically identical except I select the shipment type, sub or shipping, and use the proper query as the combo box list.

I am not familiar with writing a code to set the RowSource but I am willing to try if its not too far beyond my talents.

Can I conditionally review the shipment type and then select the corresponding combo box?

Thanks for your help,

Greg

[June7]

Options using 1 form:

1. code in Shipment Type combobox AfterUpdate event sets RowSource property of Parts combobox

2. code in Shipment Type combobox AfterUpdate event sets 2 Parts comboboxes as visible and not visible

I prefer option 1.