master button for all option buttons

[Jesse]

Is there a way to set up a "master button" that can change every
button on the page in a form?

I am an Access 2000 newbie, making some progress. I have a form that
shows all of my customers with new orders, There is an option button
group next to each of these orders in the form with 3 choices -- new,
shipped, hold. Almost always I want to change _all_ of the records to
"shipped". Or, maybe change them all in bulk, but flip 1 or 2 back.
Right now, I have to click the button in each group, 1 by 1.
Suggestions/help would be appreciated. TIA. -- Jesse.

 

[John Vinson]

Is there a way to set up a "master button" that can change every
button on the page in a form?

I am an Access 2000 newbie, making some progress. I have a form that
shows all of my customers with new orders, There is an option button
group next to each of these orders in the form with 3 choices -- new,
shipped, hold. Almost always I want to change _all_ of the records to
"shipped". Or, maybe change them all in bulk, but flip 1 or 2 back.
Right now, I have to click the button in each group, 1 by 1.
Suggestions/help would be appreciated. TIA. -- Jesse.

Since the data is stored in the Table, not on the Form, I'd strongly
suggest having your button run an Update Query updating those
customers that need updating. You'll need some sort of criteria which
match the criteria used to display the records on your form.

John W. Vinson[MVP]