I have an option group on my Access Form. I want it to be associated with record number 2 in my table (Field1 is my primary key field and the records are numbered 1, 2, 3, 4, 5, etc)
When I make a selection in the option group (I'm using checkboxes), I want the selection to be written to MyTable.
So, for example, let's say my option group has 3 checkboxes; namely "yes", "no" and "maybe". If I select the checkbox next to "no", I want the text string "no" written to Field2.
By the way, I don't care if it's better to have the record written or updated upon a change in the option group selection or by pressing a command button after making a selection. I just want the data to be written to the table. Thank you.