Adding on Option to an Option Group

[Design by Sue]

I have created a form to give a report of 3 tables and give the user the
ability to sort on a column by checking the check box on the header. I had
to add another field to one of the tables and now need to add this to the
option group.. how?

Thanks
Sue

 

[Design by Sue]

Found it - for others, you need to add the field to the record source for the
form, then with the option group selected, open the field list and drag the
new field onto the option group (at least I hope that is it)

Sue

(Sometimes it actually pays off to have a stack of books over a foot high on
Access)

 

[Design by Sue]

NOPE That didin't work - anyone have any ideas (Guess I need another 2 inches
of books)

Sue

 

[Bob Barnes]

Take one of your original radio buttons...copy & paste it INTO the Option
Group..then give it a new number..IE 3..if you had 2 radio buttons before
numbered 1 and 2.

HTh - Bob

 

[Linq Adams via AccessMonster.com]

Actually, just add a radio button to your Option Group frame and it will
automatically assign it the next number value. You'll then have to modify
whatever code you have to assign a particular report to this Option Group.

 

[Design by Sue]

Finally I found the piece I was missing in the book (pays to read one step at
a time) I needed to double click on the check box in the tool box and drag
the field name to the option group. Then the option group highlighted to
show it was selected and the item added. Then I added a field for the option
I added (of course) Then I added the option to my code.

Bob - didn't think to try past into. Will try that next time, but I think my
problem was that the option group would not select when I tried to paste a
copy.

Thanks