Make current option group choice default

[prairiewind via AccessMonster.com]

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

 

[Jeanette Cunningham]

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