Populate Option Group when date field is entered (1 Viewer)

[bdhtexas]

I have a form where users fill in a date resolved and click complete in the Option Group, it's default value is incomplete. I have a problem with the users forgetting to change it to complete when the enter the date resolved. Is there a way to change the option group value when the date resolved is entered?

 

[Pat Hartman]

If the resolved flag is totally dependent on the presence/absence of a resolved date? If it is, it is redundant and in violation of third normal form. You should remove the option group completely or make it unbound and locked and set it with code in the form's current event and the afterUpdate event of the resolved date.

 

[bdhtexas]

If the resolved flag is totally dependent on the presence/absence of a resolved date? If it is, it is redundant and in violation of third normal form. You should remove the option group completely or make it unbound and locked and set it with code in the form's current event and the afterUpdate event of the resolved date.

It is totally dependent, I will make the change, any idea what coding to use?

 

[Pat Hartman]

If you make the option group unbound and locked, you can use the following code in both the Current event and the AfterUpdate event of the resolved date.

If IsDate(Me.ResolvedDt) Then
    Me.optResolved = 2   'resolved
Else
    Me.optResolved = 1   'incomplete
End If

 

[bdhtexas]

Great, thanks for your help

I will make the changes at work in the morning and let you know how it goes or if I have any problems, work is only 9 hours away now.

 

[bdhtexas]

IF I make this an unbound object will the data in this option group update the table? I need it to continue to enter it's value in the table.

 

[Pat Hartman]

You don't need its value to be stored in the table. Any criteria that would select based on this field will work the same way against the date field.