M
Moe
my "orders" form opens to a new record every time I select a "CustomerID" in
the combobox and populates some of the fields. the "orderID" field which is
an autoNumber displays a new recordID. But if a saved data is already open,
like when I want to enter a second order, selecting a new customer does not
trigger a new "orederID" which creates the risk of accidental over writing of
an exisating order. How can I trigger the OrderID field and empty selected
fields everytime a new customerID is selected in the comboBox without closing
and reopening the form?
the combobox and populates some of the fields. the "orderID" field which is
an autoNumber displays a new recordID. But if a saved data is already open,
like when I want to enter a second order, selecting a new customer does not
trigger a new "orederID" which creates the risk of accidental over writing of
an exisating order. How can I trigger the OrderID field and empty selected
fields everytime a new customerID is selected in the comboBox without closing
and reopening the form?