How disable fields in a form?

[kikowillers]

Hi, this is my first time here and I would love if somebody could help
me.

I have a form, attached, to book drivers who will work for a company
one a certain date and I want to do the following:

When I click in the "Not Avail." or "Holiday" check boxes I want to
disable the fields "time" and "code_company" and leave available the
fields "fldate" and "code_driver" of ONLY that entry(record). But the
fields are required. I don't need the fields "time" and "code_company"
when I choose "Not Avail." or "Holiday".

How do I do this? Is it possible?

I would be really happy if somebody could help me.

Thanks in advance,

Kiko


+----------------------------------------------------------------+
| Attachment filename: schedule.zip |
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=265392|
+----------------------------------------------------------------+

 

[Marshall Barton]

I have a form, attached, to book drivers who will work for a company
one a certain date and I want to do the following:

When I click in the "Not Avail." or "Holiday" check boxes I want to
disable the fields "time" and "code_company" and leave available the
fields "fldate" and "code_driver" of ONLY that entry(record). But the
fields are required. I don't need the fields "time" and "code_company"
when I choose "Not Avail." or "Holiday".

Try using Conditional Formatting (Format menu) on the time
text box. Use the Expression Is option:
[Not Avail.] OR [Holiday]

and select the Enabled button at the right.

 

[kikowillers]

Hi!

Thank you very much for your help! It's working really well now.

Thanks,

Kik

 

[kikowillers]

Hi!

Thank you very much for your help! It's working really well now.

Thanks,

Kik