I am having a form in adp (access project with SQL Server as backend).
In order to refresh the form to view data eventualy changed by other users, I have on the form a button with following "on click" event:
Data source represents 12682 records, however after clicking, the form's record selector says "Record: 1 of 2251...". (it can be any number, but it is always far below 12682)
It seems that when executing the above code it doesn't reload all the records in the form, resulting in not relocating to the right record.
If I refresh the first 2251 records = no problem.
Refreshing a record bigger than 2251 = relocating on record 2251.
Do you have any other suggestion(s)?
Thanx in advance 'cause I spend already hours in this forum and other ones without result...
Natha
In order to refresh the form to view data eventualy changed by other users, I have on the form a button with following "on click" event:
Code:
Dim varBkm As Variant
varBkm = Me.Bookmark
Me.Requery
Me.Bookmark = varBkm
Data source represents 12682 records, however after clicking, the form's record selector says "Record: 1 of 2251...". (it can be any number, but it is always far below 12682)
It seems that when executing the above code it doesn't reload all the records in the form, resulting in not relocating to the right record.
If I refresh the first 2251 records = no problem.
Refreshing a record bigger than 2251 = relocating on record 2251.
Do you have any other suggestion(s)?
Thanx in advance 'cause I spend already hours in this forum and other ones without result...
Natha