Access Bugs? Refresh All returned to old records?

Onlylonely

Registered User.
Local time
Today, 22:36
Joined
Jan 18, 2017
Messages
43
Hi All,

I'm new to access. When i click "Refresh All" from the ribbon, it turns the "ID" to "1" instead of "New".

When i click "Add button" the initial record in "ID = 1" will be replaced. :banghead::banghead:

Any advice? Please view attachment.
 

Attachments

  • table1.JPG
    table1.JPG
    43.3 KB · Views: 65
  • table2.JPG
    table2.JPG
    48 KB · Views: 70
refresh will save new record. Autonum becomes 1.
then next record should become 2.
 
refresh will save new record. Autonum becomes 1.
then next record should become 2.

sorry I don't get you. My autonumber already in 20, once I click refresh all. It return to 1 again. If I click Add my record in 1 will be replaced and the ID become "New". If I continue click add, ID will become 21.
 
...When i click "Refresh All" from the ribbon, it turns the "ID" to "1" instead of "New"...

...When i click "Add button" the initial record in "ID = 1" will be replaced...

The Refresh All button actually does a Requery, not a true Refresh, as it would, in code, using Me.Refresh...and when a RecordSet is Requeried, it returns to the first Record displayed in the RecordSet.

Why would you expect the Refresh All button to take you to a New Record?

Linq ;0)>
 
the refresh is jumping to record 1.
when you add new, it jumps to the new record.
 
There is refresh and there is refresh all. refresh = the immediate record you are in(where the cursor is.
Refresh All = all the records, thus taking you back to the beginning of the recordset.
hope this helps.
 

Users who are viewing this thread

Back
Top Bottom