To do this, you need to save the users choices for each option group at the
time the print button is clicked.
You can save each choice on a hidden form that is always open, such as a
switchboard form that never closes, or one created specially.
Put a text box on the hidden form - one textbox for each option group.
When the print button is pressed, your code can go
With Me.Forms!NameOfHiddenForm
.txtA = Me.OptionGroupA
.txtB = Me.OptionGroupB
.txtC = Me.OptionGroupC
End With
Next time the report form opens, your code can go
With Me.Forms!NameOfHiddenForm
Me.OptionGroupA = .txtA
Me.OptionGroupB = .txtB
Me.OptionGroupC = .txtC
End With
Another option instead of using a hidden form is to use a table to store the
values.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"prairiewind via AccessMonster.com" u33121@uwe wrote in message
news:a38272af90350@uwe...
I have been wanting to make the current option group choice the default the
next time a user opens a form. I don't want them to choose all the
options
every time they print a report (option groups on form that loads at report
open determines layout, font type, size).
I getting myself confused in the effort to get this accomplished, so any
pointers, ideas, suggestions, commandments, etc. would be appreciated.
Jeff
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1