Autofill an option group based on a date field.

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I have an option group with the choices
of "Active", "Assessed Only", and "Discontinued". I need
for the option group to be updated automatically
to "Discontinued" if the field "DisconDate" has a value.
Any ideas how to do this?

Thanks,
Tara
 
In the form's Current event and the DisconDate's textbox, check for a date
in DisconDate then set the value of the option group.

Example:
If IsDate(Me.txtDisconDate) Then Me.optMyOptionGroup = 3
 
Back
Top