Please review my Access database now that i have re-done. I am trying to clear out the Quantity field after the "Order Complete"message Box appears. What code do i need here to do this? I tried using Me.Quantity = "", but this is not clearing out the field. After a person completes one order, I want the Quantity field to become blank so another order for a new quantity is needed for another product for the same vendor or a new vendor.
Any help with this VBA code is very appreciated.