Populate Option Group when date field is entered

[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?

 

[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?

 

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