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

-----Original Message-----
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 error
-----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 = False

to hide the control use:
Me.TheNameOfTheControlToBeDisabled.Enabled = True

HTH

Byron
-----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 Help

Thanks
John

.

.

.