Resetting Option Group Values

[JPritch]

I have five Option Groups on my form. I was running into a problem where after selecting options for one record and then moving onto the next record, the previous options would stay selected for the new record.

I "thought" I had found a solution by setting the Option Group values to Null in the OnCurrent event of the form, but I found a problem in that when going back to a previous record, it is nulling out the previously selected options. Doh!

Any ideas on how to get around this problem? I want to be able to go from one record to the next without carried over options, but I also want to be able to go back to already entered records without having them nulled out.

 

[FoFa]

Doesn't setting the default value for the option group cause it to reset on a new row?

 

[JPritch]

I tried but no luck. It doesn't reset.

Even if it did, I think I'm looking for another solution since I would prefer the default value be null since not all option groups will be selected. (Users will enter survey data, and not all questions will likely be answered by survey participants). So setting the default to a true condition might cause problems down the road.

 

[JPritch]

I found out why the option groups weren't resetting. It was because they were not bound to a field on my table. When I bound them, they would reset on a new record after I set the default value.

The reason they weren't bound to a field is because I didn't need the OGV. I had another invisible field on my form that would send a text value to my table based on the OGV.

I just went ahead and created new fields in my table to capture OGV, and left the fields that were populated with the text value.

Everything works fine now.