Question:
I have a have a form (frmManufactuerTub) where i have a autonumber for
maufactuer ID, i also have a datasheet subform frmPArtsUsed)
what i would like to do is on the main form when i select the hot tub
code what is made it puts all the parts for that hot tub which are
found in tblParts into the subform frmPArtsUsed (tblPArtsUsed)
then once all the intem are in the suform i can add the serial number
of any of the products and can all increase and decreas the products
uses if the hot tub needs to be speceted up or down.
Answer:
If you've ever used one of the Access New Query wizards, you've seen the use
of paired listboxes. That is, the list on the left shows what is available,
while the listbox on the right is for what is selected. I can imagine
setting up a form so that you could pick a hot tub model from a combo box
and get all of that model's parts showing in the left-hand listbox, then
select parts to be included in the exact hot tub you are building (to show
in the right-hand listbox). I assume tblParts has a primary key of PartsID, not
HotTubID (otherwise, you'd only be able to have one part per tub).
