I would like to write records from a subform with many option buttons:
YES o NO o NA o
YES o NO o NA o
...
The idea is that there is one record corresponding to each choice, and each of these choices (there are 24 sets of 3) relate to the master form record. Should I write a VBA routing to write them all after clicking a button, or is there a way to tie each group of three to a new record related to the master record? SHould IO be doing this in VB instead of Access?? (Have not done VBA for some time.) Thanks.
YES o NO o NA o
YES o NO o NA o
...
The idea is that there is one record corresponding to each choice, and each of these choices (there are 24 sets of 3) relate to the master form record. Should I write a VBA routing to write them all after clicking a button, or is there a way to tie each group of three to a new record related to the master record? SHould IO be doing this in VB instead of Access?? (Have not done VBA for some time.) Thanks.
