I don’t want the option buttons to reset each time the form is opened

[smith.jr]

I have a form with several command buttons to run different reports. I’ve added two option buttons in an option group on the form, so the user can choose to either preview the reports before printing or send the reports straight to the printer. The option buttons are not bound to anything, they are just used to preview the reports or print the reports.

When the form is opened, I would like the option buttons to “default” to what was selected when the form or database was closed. I don’t want the option buttons to reset each time the form is opened.

Thanks in advance for your help.

[pbaldy]

The only way to do that is to save the values. The simplest way to do that is to bind the form/controls to a one-record table in the front end.

[smith.jr]

Thanks Paul. I had not thought of it that way, but will try. Do you think there is a way to use an "on close" event to set the value for the option group?

[pbaldy]

Sure, you just set the value of the frame.

Me.FrameName = 1

[Missinglinq]

But there, again, it would have to be Bound to a Field in a Table...as Paul suggested.

Linq ;0)>