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

.