Form Save Record Question

  • Thread starter Thread starter depawl
  • Start date Start date
D

depawl

I have a form that opens to a specific record (Stock No.) which is
selected in a previous form. There is a combo box on this form that
allows the user to select a Vendor, and then enter data for items
purchased. It appears as though as soon as the form opens, the data
(that was selected in the previous form) is saved to the table. After
the user selects a vendor and enters data, another record is saved to
the table. Is there any way to prevent this from happening until the
user selects the "Add Changes" button?
Thanks.
 
I have a form that opens to a specific record (Stock No.) which is
selected in a previous form. There is a combo box on this form that
allows the user to select a Vendor, and then enter data for items
purchased. It appears as though as soon as the form opens, the data
(that was selected in the previous form) is saved to the table. After
the user selects a vendor and enters data, another record is saved to
the table. Is there any way to prevent this from happening until the
user selects the "Add Changes" button?
Thanks.
Click to expand...

The form shouldn't be saving the record like this. What code are you
using to open the form? Do you have any code in the Form's Open event,
or other form events?
 
There is a previous form that opens this form. In that form the user
selects an item number, and then clicks on an "Add Item" Button. This
button has a :
"DoCmd OpenForm" code in it. This appears to be what is causing the
record to be saved.
 
Back
Top