Bruce,

Oops, of course you are correct. Just a slip up.

Sorry.

By the way, great explantion.

Byron

John,

I don't think that I am clear about what you are wanting.
If you are wanting to attempt to prevent users from
accidentally unchecking the check box then you could
either present a message asking them if that really want
to uncheck the box.  You might also consider disabling
the check box after it is checked to prevent it being
unchecked again. In this case you would first need to
prompt the user that they would not be able to uncheck
the box and if they agree, disable it. You would also
need to provide some method for being able to enable the
check box if it became absolutly necessary to uncheck it,
ike maybe creating a key combination that would enable
the checkbox. All of this would just make it more
difficult for users to mess it up.

Just a couple of ideas.

HTH

Byron

Just use "If" in the code to specify whether to disable/hide or enable/show the control. In a check box, the value of a check is -1 and no check (white) is 0. (If the check box is grey, it has a null value.) The visual basic code for the After Update Event would look something like this

If [checkbox]=-1 The
    (code to enable/show
ElseIf [checkbox]=0 The
    (code to disable/hide
End I

Corrina Burnle
Burnley Data Solution
www.burnleydatasolutions.co
   
    ----- John Green wrote: ----
   
    Thanks For your help
    but how do I get the field to return to a disabled state
    when the tick is removed say in the case of an erro
    >-----Original Message----
    >John
    >>We've all had that "first time.
    >>I will assume that when you speak of a "tick" in another
    >field, that you are using either a checkbox or an option
    >button. In either case, you will need some code added to
    >the "AfterUpdate" event of your checkbox or option button
    >or, for that matter, what ever control you are using
    >>The "grey out" is refered to as disabled. So the control
    >is either enabled or disabled.
    >>The code would be like
    >>to disable the control use:
    >    Me.TheNameOfTheControlToBeDisabled.Enabled = Fals
    >>to hide the control use
    >    Me.TheNameOfTheControlToBeDisabled.Enabled = Tru
    >>HT
    >>Byro
    >>-----Original Message----
    >>Hello
    >>I am trying to create  database for the first time, and
    >>one of the things I need it to do is to hide or geayout
    >>some of the fields dependant on a tick being places in
    >>anouther field.
    >>Dose anybody know how this can be done ??
    >>>>If so Please Hel
    >>>>Thank
    >>Joh