Ms Access goes to another record after requery

[radek225]

It's really annoying.

When I click the button "open new order" after that my form it's open with new id and it's ok, but when I push the key "F5" then Ms Access goes to another record (no new record). Why is that?

 

[pr2-eugin]

Because the New record is not created, when you refresh, the underlying Query is refreshed too.. Since the New record which seemed to exist actually never was there..

Now explain what is your actual problem, so we could offer you a better solution.

 

[radek225]

I checked and the record was created in the tables, so when I refresh form, the new record exist in tables. All I want is open form with new id and only with this id, without options to move to previous or next or new record.

 

[Dewi]

Hi, not entirely sure what you are aiming for however you could try this....

DoCmd.RunCommand acCmdRecordsGoToNew

on the onload event of the form, or on the form properties Data/DataEntries/Yes this restricts the form to new entries only.

You could also use allowedits = no so that although you can move to previous records you cant do anything with them.

there are a few options , which may suit you

cheers.