Requery Question

[wojo]

I have successfully used the requery function, however, I don't get the
result I desire.
When the form is requeried the 'cursor' ends up in the first record in
the form and I would like, after requery, for the cursor to end up in
the last updated record.

Is there a way to accomplish this?

Jo

 

[Al Camp]

wojo,
Check out Stephen Leban's SetGetSB.zip. I has code that ...
Restores current row's position after a Requery.
http://www.lebans.com/setgetsb.htm

 

[wojo]

Thank you, I'll take a look at it.

Jo
Manchester, NH (help was so close!)

 

[wojo]

Al, I tried to get the file, but it is for an earlier version of Access
(I think). I'm using 2003. When I tried to open it (it's read only)
my program said the first time you open an earlier version of a
database, you must have write capabilities.

Any ideas how I can open the file?

Jo

 

[Al Camp]

wojo,
Open a new blank 2003 file, and import all the objects (tables, forms,
modules, etc...) from Stephen's 97 version.
That should do it.

 

[warrior]

try
me.[fieldname].setfocus