VBA to set a hidden field depending on criteria

[snipe]

Hey guys,

I have a very normal data entry form: name, address, phone, email. There is an hidden field for "Can we mail them?" If address and email is null, this value needs to be 2, otherwise it needs to be 1. I know how to write the code to do that. I just can't figure out which event of which control to put it on. I have tried it on the email and the address field, but I have to program for this so it works no matter how people decide to use it. Some people tab thru the fields, some click, some don't key in the normal order. Etc..



Which event would you guys use?

[snipe]

Before Update of the form.... derp... Hadn't finished my coffee yet. Sorry guys!