keeps adding new records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database. I have several forms that are interconnected. I
have one main form that then with the use of buttons goes into different
forms. the problem that I am having is that every time I push a button on
the main form togo into a record I get a new record created. I want to just
see one record unless I purposefully create an new record. I have tried a
select case code, I have tried save a record, I am getting frustrated because
everytime it creates a new record. Thanks for the help
Randi
 
Randi said:
I am creating a database. I have several forms that are
interconnected. I have one main form that then with the use of
buttons goes into different forms. the problem that I am having is
that every time I push a button on the main form togo into a record I
get a new record created. I want to just see one record unless I
purposefully create an new record. I have tried a select case code,
I have tried save a record, I am getting frustrated because everytime
it creates a new record. Thanks for the help
Randi
Click to expand...

Simply navigating to the new record position will not cause a record to be
created unless the user, a macro, or some VBA code is setting the value of at
least one field. Do you have any such Macro or code in the form's Current
event?
 
Back
Top