Re: Form control

From: kp2864 (anonymous_at_discussions.microsoft.com)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 10:24:40 -0800

I don't want to track dates I just want upon entry of
info in the field (upon update of the field) I want it to
trigger just one of the radio buttons being selected in
the options group. the
control; Option101 or Option.... etc.

>-----Original Message-----
>On Thu, 12 Feb 2004 09:11:13 -0800, kp2864 wrote:
>
>> I have a form where I want the entry of dates in
certain fields to
>> trigger the selection of one of the radion buttons
being selected
>> in my options group shown at the top of my form. This
options
>> group represents the status of the record item.
>
>Let's assume you wish to track future date, current
date, and past
>date entries.
>
>Code theAfterUpdate event of the Date field:
>
>If Me![DateField]> Date Then
> ' Future date
> OptionGroupName = 1
>ElseIf Me![DateField] = Date Then
> ' Today's date
> OptionGroupName = 2
>Else
> ' Past date
> OptionGroupName = 3
>End IF
>--
>Fred Please only reply to this newsgroup. I do not reply
to personal
>email.
>.
>