From: Jen32 on 5 Jan 2010 15:46 That seems to have done the job Fred thanks...the form is displaying the control as greyed out when i open it again. There's one other small thing (typical woman i know !)....i've got a report based on that form which displays the list of managers names down the left hand side and the relevant info opposite. When i run the report, all the managers names are greyed out instead of just the one i selected. Is it possible just to have the one i selected or is it more trouble than it's worth ? Thanks again, Jen fredg wrote: >> Hi Fred, >> Thanks for the reply. I tried your suggestion and it worked fine in the >[quoted text clipped - 29 lines] >>> >>>Substitute your actual control names. > >What happens if you use: > >Me.[Manager].Enabled = (Nz(Me.[Check39] ,0)= 0) |