Solved Forms- little problem access 2007 (1 Viewer)

[Deleted member 159944]

Hello,

i am having a problem access 2007 at the FORM section only.

The new records i am adding they are not saved at the next number of the form (e.x now i am at 1479) but they are getting the number of the old records, starting every time i open the file from 1 record

For Example : i press the button for a new record at the "FORMS enviroment" , when i press save, the database saves it as record 1 and tranfers the record 1 to the record 2, etc

Note: at the "TABLES enviroment" the records appear normal 1-->1, 2-->2 etc, which is Great!! - since i want to keep the corresponds to my physical files.

Also this started by accident from the keyboard when i pressed a shortcut and by accident, i pressed an other key of what i wanted to, i think that some kind of setting has been changed...

Does anyone know how to fix this? It is pretty annoying and some times confusing... Thx!

 

[CJ_London]

Cross posted here https://www.accessforums.net/showthread.php?t=84748

recommend responders review it as it has some screenshots and covers the normal reason for this happening

 

[Minty]

Yes, I know how to fix it.

Read the answers provided already. You change the setting on your form, by accident by the sounds of it.

 

[Gasman]

Seems O/P paid no attention to my crossposting advice?