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.