I need to make a correction to this.  A logical field can contain only 0/1
true/false or yes/no values in the table.  If you wish to use Y/N then you
must create a text field [make it 1 character long] and the code should
work.

Mike Buraczewski
[log in to unmask]

-----Original Message-----
From: Mike Buraczewski <[log in to unmask]>
Date: Friday, July 09, 1999 2:14 AM
Subject: Re: [PCSOFT] option button in Access


>Hi Norm.
>
>If I understand your question, you have bound an option button to a logical
>field on your form.  Then when you select the option as true, the field
>says -1 and for false it says 0.
>
>You need to put some code behind the button, probably in the after update
>event.  Assuming the name of your option button is "button1" and your field
>is "field1" try this:
>
>if me.button1.value=true then
>    me.field1.value="Y"
>else
>    me.field1.value = "N"
>end if
>
>I have created an example that I can send you privately if you like.  Just
>send me a message.
>
>Mike Buraczewski
>[log in to unmask]
>

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                       Drew Dunn<[log in to unmask]>