Added field for new option group results in null error

[markjkubicki]

To an existing table, I added a new integer field to capture the user’s choice for a related new option group on a subForm
Existing records in the table are understandably null for this value (seems to be correct -yes?). The default is 0 for new records.
When it and it’s parent form opens, some formatting occurs that is based on the value of the option group. Consequently, the null value is causing error.

I could cycle through all the records and assign a value to the field when the field is created (on each of the many parallel back end tables.
or
I could assign a value to the field in the forms OnCurrent event (if null)
or
I could Nz() throughout the code (although a null would make no sense to the user)

Is their a best practice on this?

Thnx in advance,
m.

[Welshgasman]

I'd use an Update query to set them all to zero.?

[markjkubicki]

thnx
...works for me