action after check box

[Guest]

I'd like 2 fields to be updated when a check box is checked (or unchecked).
One field with current date and one with checkbox value.
If checkbox was checked but the check is removed the date should also be
removed and the date field should be empty.

is this possible?

 

[Rick B]

Yes, just build code in the checkboxes "Change" event.

This is asked alllll the time. You can do a search and find specific
examples of the code if you need more details.

Rick B

 

[Guest]

Hi, Robin.

In the checkbox' OnChange event procedure:

If Me!MyCheckBox = True Then
Me!MyDateControl = Date()
Else
Me!MyDateControl = Null
End If

Hope that helps.
Sprinks

 

[Guest]

Rick,
I would just point out that finding the wording for a search can be
difficult sometimes. Without knowing that there is such a thing as a change
event, a search pertaining to this question is difficult to frame in such a
way as to produce relevant hits. Also, some people are using the web-based
newsreader, so searching is a different process than with a newsreader such
as OE. Until I learned about Google Groups searching was a frustrating
process indeed.

 

[Guest]

Bruce,
I only have used the newsgroups in Microsoft's website which tend to be very
tedious. Can I get to the equivelant Newsgroup by using a standalone news
reader? Do I log in using my normal newserver or microsofts?

Thanks!
MikeZz

 

[Guest]

Most e-mail programs also function as newsreaders. How to set it up depends
on the program. Our current setup at work (firewalls or proxy server
settings or something) does not allow me to use a newsreader, so I would not
be the best person to advise you. The MS web site contains information, I
believe, as will your e-mail program's Help. Your ISP may also provide a
way, as some of them have a newsreader server. A Google groups search will
produce a wealth of information. The catch is that if you are at work you
may need specific permission to use anything other than the company's default
e-mail servers.