Form - First & Last

[Bill]

Hi,

I have 35 records. When I add the record and update some fields, I create
Me.Requery on one of the field. Is there a way to stay on the current form
(36th records) while I input information? Because one of the field has
Me.Requery and I put some data and it goes back to #1 records instead of
36th records. How I can stay on the form #36 records and then go on #37
for not going back to first record ?

Your help would be much appreciated.

Thanks.

 

[Jeff Boyce]

Bill

The construction
Me.Requery
requeries the entire form, not the field. The "Me" refers to the form.

The record displayed depends on whether you are using the DataEntry
property, on what the underlying record source (and sort order) is, on
filters you may have set, on ...

By the way, the numbers at the bottom left are NOT record numbers. They are
a count of records. If your data doesn't have any record number field, your
records don't have record numbers.

 

[Bill]

Try this after the requery:
DoCmd.GoToRecord , Me.Name, acNewRec
HTH
bill

 

[Yan-Hong Huang[MSFT]]

Hello Bill,

I was reviewing the issue thread. Do you have any more concerns on it? If
there is any unclear, please feel free to post here.

Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.