Originally Posted by
dmon2010
...I have a form that I've set to open to a blank record so information can be entered as soon as the form is open...
How, exactly, have you accomplished this? If you have the Data Entry Property set to Yes the existing Records aren't available, and hence 'Find' is useless. If that's the case, change the Data Entry Property back to No, and use this code to open to a blank, new Record:
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007