Link to home
Start Free TrialLog in
Avatar of Jenkins
JenkinsFlag for United States of America

asked on

Option Group on a Form

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.

That is:

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

OR

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).

Thanks
SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jenkins

ASKER

Thanks
You are welcome!