Validation Rule

[snowsride]

I have a form with several option buttons and a text box formatted as a date. I want the validation rule for the date box to vary depending on which option box has been checked. I have tried:

=iif([Option1],True,>=#01/07/2000#,>#01/01/2000#)

I haved tried enclosing the Truepart and Falsepart of the iif statement in quotes and substituting 1 for True but none of the variants I have tried will work.

Any ideas please?

 

[Jack Cowley]

In the After Update event of the Option Box try code like this:

Select Case OptionGroupName
Case 1
Me.TextBoxName = #1/1/2002#
Case 2
Me.TextBoxName = #1/2/2002#
Case 3
Me.TextBoxName = #1/3/2002#
End Select

Change the names above to the actual names of your Option Group and the text box to get the date.