B
Bob Waggoner
Access 2003; XP
When I go into design view on a form and then return to form view, I get a
runtime error 2105 that says I cannot go to the specified record. Why can't I
go to a new record when I load or open a form from design view?
My code is:
Private Sub Form_Load()
On Error GoTo Err_form_load
DoCmd.Maximize
DoCmd.GoToRecord , , acNewRec
Exit_Form_Load:
Exit Sub
Err_form_load:
DoCmd.GoToRecord , , acLast
Resume Exit_Form_Load
The err_Form_load: is desgined to accept the error and move to the last
record. But, despite that, it still gives me the access message and then
reverts to the first record when I say END. (I don't want the user clicking
debug!)
Access 2003 - recently converted from 97.
Any help would be appreciated.
When I go into design view on a form and then return to form view, I get a
runtime error 2105 that says I cannot go to the specified record. Why can't I
go to a new record when I load or open a form from design view?
My code is:
Private Sub Form_Load()
On Error GoTo Err_form_load
DoCmd.Maximize
DoCmd.GoToRecord , , acNewRec
Exit_Form_Load:
Exit Sub
Err_form_load:
DoCmd.GoToRecord , , acLast
Resume Exit_Form_Load
The err_Form_load: is desgined to accept the error and move to the last
record. But, despite that, it still gives me the access message and then
reverts to the first record when I say END. (I don't want the user clicking
debug!)
Access 2003 - recently converted from 97.
Any help would be appreciated.