FormA (switchboard) field1 are JobOrders field2 are subJobOrders
field1 field2
cbobox cbobox
AfterUdate looks for the all or one subJobOrders AfterUpdate Together field1 and field2 Opens
Form B which inputs field1 and field2 into tblMain
FormB has three command buttons
cmdbutton1 cmdbutton2 cmdbutton3
Docmd.Close (Closes FormB) Docmd.Close (Closes FormB) cmd.Close
Docmd.OpenForm FormA Docmd.CloseA
I do this to bring FormA in order to Add Docmd Open A
More field2 to the same field1 I do this to clear the cboboxes
so I can choose Another Joborder
Is the another way (easier way) to clear cboboxes without closing and reopening the form?
Start Free Trial