How disable fields in a form?

  • Thread starter Thread starter kikowillers
  • Start date Start date
K

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|
+----------------------------------------------------------------+
 
kikowillers said:
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".
Click to expand...


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.
 
Hi!

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

Thanks,

Kik
 
Hi!

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

Thanks,

Kik
 
Back
Top