Move from last field in form

[jlr]

What is the best way to move from the last field on the last page of a form to a new record field on the first page?

 

[vbaInet]

Are you asking what is the way of moving to a new record from the last record?
What view is the form in?

 

[jlr]

I need the VBA code I think, written to go from the last field in a form which is on the last page(tab) of the form aftering entering the data in this field, to jump to the first field of the first page (tab) to enter a new record.

 

[vbaInet]

Don't you think it will be a nuisance if after entering incorrect data in the last textbox it suddenly jumps to another page?

 

[jlr]

No. There are more steps in getting to a new page and new record. Person entering data should review before selecting Enter key. Can also run a report to determine if data has been entered correctly.

 

[vbaInet]

That's your prerogative.

1. Set focus to the page
2. Set focus to the control

Look into SetFocus method.