How can I have a database load to a new record.

If I place the following line in a button event it adds a new record as it should.

Data1.Recordset.AddNew

But if it is placed in the load event I get the following error.

"Object variable or With block variable not set"

I am guessing it is because the data has not been loaded prior to the command in the load event.

Is there a way that I can "preload" the data before executing the Data1.Recordset.AddNew command?