Access Bugs? Refresh All returned to old records?

[Onlylonely]

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.

 

[Ranman256]

refresh will save new record. Autonum becomes 1.
then next record should become 2.

 

[Onlylonely]

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.

 

[missinglinq]

...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)>

 

[Ranman256]

the refresh is jumping to record 1.
when you add new, it jumps to the new record.

 

[Cookiewl]

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.