In my form I want to lock a field from data entry or make it a grey shaded non active box (I know all the technical terms!!!), until another box has data in it.

Any help.

Ian

I feel so proud.............I've just noticed I've become a MEMBER (No comments please!!)........Thank you.

MORE IMPORTANT CAN ANYONE HELP ON THE ABOVE QUESTION?

Ian

congratulations!

You need to set its enabled to false by default and then do something on either exit or after update like

if not isnull(me.GottaHaveDataBox) and me.GottaHaveDataBox<>"" then
me.CurrentlyDisabledBox.enable
else
msgbox "Put something in the box please"
'cancel=true '- if on exit and u don't want them to move on unless it's filled out
end if


HTH

Drew