continuous forms -- setting properties

[Guest]

Hello,

I have a continuous form in which I would like to conditionally set the
properties on a row by row basis. For example, if the status of the record
is "closed", I would like to disable all controls for the record, some of
which are combo boxes. Is there a way to do this when the form first displays?

Thanks for your help

 

[Allen Browne]

You cannot condtionally hide or disable controls on some rows of a
continuous form. It's the entire column, or nothing.

However, the user can only use the controls in the current record. The
others are only paint on the screen. So, you can use Conditional Formatting
to make the other rows *look* disabled, and use the Current event of the
form, or the Enter event of the control to disable it or prevent the user
actually getting in there.

 

[Guest]

Allen,

Thanks for your prompt reply. Your suggestion sounds good. I will give it
a shot.

Thanks