DoCmd.GoToRecord , , acNewRec seems to be replacing records in table

[drdexter33]

I'm not an Access Developer, but I've been asked to figure out what the problem is with our little homegrown Access app.

When a user clicks on a button to add a person to a table, it looks as if the existing record in the table is getting updated, instead of appending the record to the table.

The sub looks like this:

Private Sub btnNewPt_Click()
DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl "EmpNum"
End Sub

But i can't figure out how this table is actually getting updated..

Thanks

doug

 

[KiaruB]

Hello,

the acNewRec doesn't create a new record, it just puts you in a position to enter a new record in a 'clean' form, the new record is created only after you enter data into the 'clean' form

greets.