Skipping records in Data Entry Mode

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

Guest

Hi everyone
I have a fairly complex form that is opened in Data Entry mode. The user
can subsequently change the mode to 'normal view' via a command button so
that the form can either be used to view all previous records OR to input new
ones (i.e. Data Entry mode is either on or off). When going from viewing to
inputting, the Autonumber (primary key) field skips two numbers each time.
The skipped records aren't actually being saved but I'm concerned that things
aren't as they should be. I've ensured that the background table doesn't
have any Default values in case it was generating new records automatically
but as I say it doesn't save the skipped records. There is a field (not the
primary key) that has a default value (at the form level) but I don't think
this is the problem. Can I do anything to stop this happening? Do you have
any other suggestions?
Kind regards,

Lee
 
It sounds like Access is simply applying its defaults to your app. It
happens. The solution is to simply figure out what ID you want the form to
go to when the user switches from viewing to inputting, and then go there.
Expecting Access to follow the logic that you require is, I'm afraid, not
going to work.
 
Back
Top