Hi everyone,
I'm gradually getting to grips with my database but now I need to display the results of the second column of a subform in a combobox on the main form.
Basically, users enter a PartID in a text box on the main form. The subform then displays the corresponding PartID, WHLocatID (warehouse location) and LocationQty (stock quantity in the location) from the Inventory table.
This works well (simple but a big "victory" for me ).
But... now im stuck!
Back on the main form, I have a combobox called cboWarehouseLocat which I want to only display the WHLocatID details as shown in the subform for the PartID that was given originally.
Is this all possible at all?
Many thanks as always!
Chris
I'm gradually getting to grips with my database but now I need to display the results of the second column of a subform in a combobox on the main form.
Basically, users enter a PartID in a text box on the main form. The subform then displays the corresponding PartID, WHLocatID (warehouse location) and LocationQty (stock quantity in the location) from the Inventory table.
This works well (simple but a big "victory" for me ).
But... now im stuck!
Back on the main form, I have a combobox called cboWarehouseLocat which I want to only display the WHLocatID details as shown in the subform for the PartID that was given originally.
Is this all possible at all?
Many thanks as always!
Chris