I have an Access form whose record source is MyTable.
On the form, I have a textbox named Pay_Date used for selecting/entering a date value.
It does not require that a value be entered (to be explained below).
The Pay_Date textbox's control source is the Pay_Date field whose data type is Date/Time and is in MyTable.
There are 4 possible scenarios that can exist as far as Pay_Date goes. They are:
1. The date is known, therefore the user can select/enter it in the Pay_Date textbox.
2. The date is missing.
3. The date is not legible.
4. The date is not applicable.
Because I cannot set up a situation (which would be the ideal) where the Pay_Date textbox alone
can be used to either enter a date or select "missing", "not legible" or "not applicable"
(because its data type is Date/Time), I'm going to try what seems to me to be the next best thing.
Have the user either enter a date value into the Pay_Date textbox or, if applicable, leave it blank
and make a "Missing", "Not Legible" or "Not Applicable" selection from an option group placed to the
right of the Pay_Date textbox.
Which leads me to the following:
I need code that will make the option group inactive (and none of the buttons populated) if the user
selects/enters a value in the Pay_Date textbox
If the Pay_Date textbox is left blank or populated and then blanked out (if for example the user enters
something and then erases/deletes it), I want to have the option group activated. Of course from the start
both the Pay_Date textbox and the option group will need to be active. At that initial stage, I don't want
any of the buttons to be selected (because it is not known yet whether the user will enter a date or make
an option group selection).