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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007