In the form you can lock or disable controls based on who is signed on.
You could also split the table into two (one-to-one) related tables and
apply different security to each one.

Signature
Rick B
> Is there any way i can make half the fields of a table read only but the
> other half editable depending on the userl? if its the admin then the
> talbe
> should be regularly editable.
>
> thanks
MikeP - 10 Aug 2006 14:50 GMT
thanks
How do you lock or disable controls based on who is signed in?
Mike
> In the form you can lock or disable controls based on who is signed on.
>
[quoted text clipped - 7 lines]
> >
> > thanks