O
Onytay
I want to use a form to edit data from a table and store the edited data in
another table. Specifically, I would like to have the user select a PCBoardID
from a combo box
on the form and have the subform autofill with data from a table that
contains a list of the PC boards component details using several fields. The
user could then edit the fields as needed in the subform and store the edited
data in a new table while leaving the source table intact. Currently I have a
table tblBoards that contains the boards we make and another table
tblBoardBOM that contains the board component details that needs to remain
intact. I also have a form (frmKit) with a combo box (cboBoard). I need help
autofilling the subform (KitSubform) with the data from tblBoardBOM and then
storing the edited data in another table (tblKitBOM).
another table. Specifically, I would like to have the user select a PCBoardID
from a combo box
on the form and have the subform autofill with data from a table that
contains a list of the PC boards component details using several fields. The
user could then edit the fields as needed in the subform and store the edited
data in a new table while leaving the source table intact. Currently I have a
table tblBoards that contains the boards we make and another table
tblBoardBOM that contains the board component details that needs to remain
intact. I also have a form (frmKit) with a combo box (cboBoard). I need help
autofilling the subform (KitSubform) with the data from tblBoardBOM and then
storing the edited data in another table (tblKitBOM).