Cursor move when adding new record

[ahmadshahin]

Dear mates ,

I made a simple database with tables and forums...
but when i add the second record through the form the cursor is still on the first one and so it updates the old one instead of adding a new record

I want a new code to make the cursor move to the next record

 

[geregs]

Check the Allow additions on your form, it should be Yes.
Also try to go to new record with record navigations.

 

[pl456]

You could use a macro to force it to a new record or code as below

DoCmd.GoToRecord objecttype, "objectname", record, offset

Changing the various bits fo the code to the names of your forms etc.

 

[MStef]

CYCLE properties put on ALL RECORDS.