Active & non active fields

[ian_ok]

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

 

[ian_ok]

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

 

[KDg]

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