Clearing Checkbox when Entering Text

[Guest_imported]

I need the command for the event procedure for "After Update" in the text box. I want it so when you enter text into the text box, the check box automatically clears. I tried

me!checkbox = False

but it's not working. I get this error saying I can't assign a value to this object.

Any ideas?

 

[jplum]

Try this:

me.checkbox = 0

A yes/no field stores a yes as -1 and a no as 0.

Jennifer

 

[Guest_imported]

No, I tried it, it says I can't assign a value to the object. Any other ideas?

 

[jplum]

How about me.checkbox = null?

 

[Guest_imported]

No dice, sorry.. I have no idea what will work.

 

[jplum]

Can you send me your database or at least your form so I can take a look at it?

plumj@calib.com

Jennifer

 

[CTOROCK]

is your form bound to a query that is read only? Otherwise I don't see how it doesn't work. how about trying to set it focus first? "The greatest risk, is not taking one."

 

[EarS]

Have you tried just reffering to the name of the text box and setting it = to false.

forms!formname!checkboxname = False

or if its in the current scope

checkboxname = false

Just a thought.