Hi,

I want to add a new record to my database on the form load event - that is, as soon as my form loads the text box will be blank, which will enable the user to input info that will then be added to the database.

When my code is this, however:

Private Sub Form_Load()
Data1.Recordset.AddNew
End Sub

I keep getting a run-time error '91'; object variable or With block not set

I'm sure there's some way around this, but I don't know how. Please help!

Thanks