I missed the beginning of this, so I'm not sure why Norm needs to create a
button that fills in a yes/no field on the same form.  It sounds like a lot
of extra work (or did I miss the point?).  Wouldn't a checkbox accomplish
the task quicker and easier?

Jim Meagher
=====
Micro Solutions Consulting        Member of The HTML Writers Guild
http://www.ezy.net/~microsol     International Webmasters Association
410-543-8996                MS Site Builder Network - Level 2 member
=====
----- Original Message -----
From: Mike Buraczewski <[log in to unmask]>

> 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
> >
> -----Original Message-----
> From: Mike Buraczewski <[log in to unmask]>
>
> >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.

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