clear past data during form open

**newaccess** · 01-09-2013, 10:41 AM

I have access 2007 on window 7.
I use form wizard to auto generated a form to add data. Now I want to clear past entered data when form open.
Otherwise, I can see last enter data during open a form.
on form current, I put Me.test_name = Null But I get error as
RUN-TIME ERROR'-2147352567(80020009)
YOU tried to assign the null value to a variable that is not a variant data type.

How to fix this issue?

Thanks for any help!

new access man

**pbaldy** · 01-09-2013, 10:55 AM

Would setting the form's Data Entry property to Yes do what you want?

clear past data during form open

Thread Tools

clear past data during form open

Similar Threads

Open form to enter data

Code to open form, open a new record, input data, then close form

Problem getting new data to an open form

Problem getting new data to an open form

OPen Form to add data

Posting Permissions