Go to new record Error.

[Bob Quintal]

=?Utf-8?B?RS1tYWlsIHJlcG9ydCB1c2luZyBMb3R1cyBOb3RlcyByYXRoZXIgdA==?=

Hi,

I have a form and when I open the form with a command button it
opens the form and goes to the last entry in the form. but when I
convert the database to mde file, split it in the share drive and
give each user a copy of the front end, the go to record code is
not working. It give me an error and won't open the form. Why is
that. After that, I put "On Error Resume Next" it works and open
the form but it does not go to the end of the record. Please help.

Onclick:
on error resume next
Focmd.openform "formname"
DoCmd.GoToRecord , , acNewRec

Sounds like the back ebd db is read only , or that when you move the
files to the back end, the links need to be changed to use the
correct path.

Just setting an on error resume next without noting the error number
and determining what is causing the error is a total waste of time
and effort.

 

[Guest]

Hi,

I have a form and when I open the form with a command button it opens the
form and goes to the last entry in the form. but when I convert the database
to mde file, split it in the share drive and give each user a copy of the
front end, the go to record code is not working. It give me an error and
won't open the form. Why is that. After that, I put "On Error Resume Next"
it works and open the form but it does not go to the end of the record.
Please help.

Onclick:
on error resume next
Focmd.openform "formname"
DoCmd.GoToRecord , , acNewRec