Run-time error '2105': You can't go to the specified record.

I have a "Save and New" button on my form which essentially adds a new record.


Here's the code:

Code:

Private Sub Command480_Click()
DoCmd.GoToRecord , , acNewRec
With Me.RecordsetClone
.MoveLast

When I click the button, an error pops up saying Run-time error '2105': You can't go to the specified record.
When I debug, it highlights the DoCmd line (DoCmd.GoToRecord , , acNewRec)

Last time I used the form (3 days ago), everything was working fine. No idea what the problem is.

Thanks in advance!

IF you simply want to go to a New Record, what is this

Code:

With Me.RecordsetClone
.MoveLast

supposed to be doing? The single line

DoCmd.GoToRecord , , acNewRec

should do what you're trying to do. I'd simply try that line by itself.

BTW, in using Access for the past 12 years, one thing that I've seen, repeatedly, is that the Access Gnomes frequently do not actually hilight the errant line of code, but rather the line of code before the problem one! That would mean that the problem line, here, would be the

Code:

With Me.RecordsetClone
.MoveLast

part. Also, where is the rest of the OnClick sub?

Linq ;0)>