D
David#
I have a form “StopOrders†with a PK [StopNumber] writing to a “StopOrdersâ€
table. While this form is opened, I open “SelectStopDetail†which consists
of two cbo’s, one cbo limited by value selected in the other. I need to
write value of both combo’s PLUS the PK from “StopOrders†to my “StopDetailâ€
table. I can’t seem to capture the [StopNumber] to this “StopDetail†table.
(I AM getting the combo values over there... just not the PK form the other
form.) A subform won’t work because changing first combo box affects values
in ALL other combo boxes. How can I capture the [StopNumber] and write it
to the “StopDetail†table?
table. While this form is opened, I open “SelectStopDetail†which consists
of two cbo’s, one cbo limited by value selected in the other. I need to
write value of both combo’s PLUS the PK from “StopOrders†to my “StopDetailâ€
table. I can’t seem to capture the [StopNumber] to this “StopDetail†table.
(I AM getting the combo values over there... just not the PK form the other
form.) A subform won’t work because changing first combo box affects values
in ALL other combo boxes. How can I capture the [StopNumber] and write it
to the “StopDetail†table?