G
Guest
I have a form that enters products into a Bill of Materials (description and
cost). The input form allows the user to type in a product manually or click
a "Add From List" cmd button. On click, another form opens that has a list
box and 2 text boxes. When the user clicks an item in the list box (OnClick
event) the description and cost are loaded into a global variable and then
appear in the corresponding text boxes. Once the user is certain they have
selected the correct product, they click a cmd button that closes the list
box form and "SHOULD" load the global variables into a new record set of the
Bill of Materials form. The problem is I can't work out the code to transfer
the variables. My path of thinking is to set the current record of the Bill
of Materials to New in the OnClick event just prior to opening the list box
form. Then the OnClick event for the cmd button on the list box form should
load the record set before closing itstlsef. Yes? No? How?
cost). The input form allows the user to type in a product manually or click
a "Add From List" cmd button. On click, another form opens that has a list
box and 2 text boxes. When the user clicks an item in the list box (OnClick
event) the description and cost are loaded into a global variable and then
appear in the corresponding text boxes. Once the user is certain they have
selected the correct product, they click a cmd button that closes the list
box form and "SHOULD" load the global variables into a new record set of the
Bill of Materials form. The problem is I can't work out the code to transfer
the variables. My path of thinking is to set the current record of the Bill
of Materials to New in the OnClick event just prior to opening the list box
form. Then the OnClick event for the cmd button on the list box form should
load the record set before closing itstlsef. Yes? No? How?