If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Make current option group choice default
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 |
#2
|
|||
|
|||
Make current option group choice default
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 |
Thread Tools | |
Display Modes | |
|
|