clear post data during access 2007 form open

newaccess

Registered User.
Local time
Today, 00:50
Joined
Apr 6, 2011
Messages
27
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!

newaccess
 
YOU tried to assign the null value to a variable that is not a variant data type.

Which part of this sentence is not clear to you?
 
I use form wizard to auto generated a form. I want to clear past added data on the form when form opening.

i find solution in gogle.
just as test_name .Value = ""
 
Last edited:

Users who are viewing this thread

Back
Top Bottom