change which toggle button appears pressed from results in a table

[Karen C via AccessMonster.com]

How can I change the toggle button that is pressed in through code? I have
a form with toggle buttons to select a company division which is stored in a
table. Other selections on the form run macros to print specific reports for
the selected division. A small number of the macros change the division to
print reports for related divisions. I haven't yet figured out how to make
the button for the second division appear depressed when the macro changes
the division in the table. I need for the user to know what division the
processing ended. Thank you in advance for any help.

 

[Marshall Barton]

How can I change the toggle button that is pressed in through code? I have
a form with toggle buttons to select a company division which is stored in a
table. Other selections on the form run macros to print specific reports for
the selected division. A small number of the macros change the division to
print reports for related divisions. I haven't yet figured out how to make
the button for the second division appear depressed when the macro changes
the division in the table. I need for the user to know what division the
processing ended. Thank you in advance for any help.

Are the toggle buttons contained in an oprtion group?

How is a division identified, by name or by what kind of ID
number?

Are you really using macros or is that just a term you use
for VBA procedures?

 

[Karen C via AccessMonster.com]

The toggle buttons are in an option group, identified by division ID#. All
reports are for a division, based on the selection in the option group. There
are instances where one user runs a series of reports for several divisions.
The user was shown how to set-up the division and report selections in a
macro that he maintains when changes are desired. I'm setting up a form for
all user's to be able to select a division and a report to print. (The toggle
button is pressed and the division name is displayed) I am also putting this
users 'books' on the menu. The macro changes the division ID# in the table
and the division name on the form. I need to keep the toggle button in sync
with the division name. I appreciate any help you can provide.

How can I change the toggle button that is pressed in through code? I have
a form with toggle buttons to select a company division which is stored in a

[quoted text clipped - 4 lines]

the division in the table. I need for the user to know what division the
processing ended. Thank you in advance for any help.

Are the toggle buttons contained in an oprtion group?

How is a division identified, by name or by what kind of ID
number?

Are you really using macros or is that just a term you use
for VBA procedures?

 

[Marshall Barton]

I'm sorry Karen, but I'm just not following what you are
trying to describe.

It almost sounds like the user can use(?) some kind of macro
to pick(?) some(?) divisions on one form and you want
another form's Option Buttons Caption and OptionValue
properties to reflect what was selected(?) on the first
form???

You also mentioned changing the division in some(?) table,
but I don't have a clue how/where/when that comes into
play???
--
Marsh
MVP [MS Access]

The toggle buttons are in an option group, identified by division ID#. All
reports are for a division, based on the selection in the option group. There
are instances where one user runs a series of reports for several divisions.
The user was shown how to set-up the division and report selections in a
macro that he maintains when changes are desired. I'm setting up a form for
all user's to be able to select a division and a report to print. (The toggle
button is pressed and the division name is displayed) I am also putting this
users 'books' on the menu. The macro changes the division ID# in the table
and the division name on the form. I need to keep the toggle button in sync
with the division name. I appreciate any help you can provide.

How can I change the toggle button that is pressed in through code? I have
a form with toggle buttons to select a company division which is stored in a

[quoted text clipped - 4 lines]

the division in the table. I need for the user to know what division the
processing ended. Thank you in advance for any help.

Are the toggle buttons contained in an oprtion group?

How is a division identified, by name or by what kind of ID
number?

Are you really using macros or is that just a term you use
for VBA procedures?

 

[Karen C via AccessMonster.com]

Marshall, thank you for trying to help me. This is the first time I've tried
to post a question. In my attempt to keep it simple, I made it hard. As I
haven't been able to do what I was trying, I am taking a new approach to the
task. I will certainly use this forum again in the future. I've been able to
get many answers from other posts. Thank you again for your time and attempt
to understand the issue. Karen

I'm sorry Karen, but I'm just not following what you are
trying to describe.

It almost sounds like the user can use(?) some kind of macro
to pick(?) some(?) divisions on one form and you want
another form's Option Buttons Caption and OptionValue
properties to reflect what was selected(?) on the first
form???

You also mentioned changing the division in some(?) table,
but I don't have a clue how/where/when that comes into
play???

The toggle buttons are in an option group, identified by division ID#. All
reports are for a division, based on the selection in the option group. There

[quoted text clipped - 20 lines]