Need design advise on option group and storing the value

[TrailblazerLS]

My user would like to tag their account records as a type 1 Or type 2 Or type 3. I originally set this up as an Option Group (with checkboxes) and stored the value "1" or "2" or "3" into a text field in the table. However, the fields on the form are checkboxes and this is causing some havoc with legacy code. (When form is opened, on a new form, all checkboxes are set to false), I am getting an error message that I cant assign a value to an object....I know its the option group). I could create 3 separate fields and store the appropriate value in each...what is the best way to design this.

 

[dhookom]

We don't know what your "legacy code" looks like. Your field should be numeric, not text. Your option group can be bound to your numeric field. Updating the group will update the field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[TrailblazerLS]

Without going into a lot of detail, I fixed the problem.
Originally it was a check box within an option group...but I changed the control to a radio button.