Option Group Use

[Brian Dehning]

Would what be the best way to do the following

I want to use an Option Group with choices of "Monthly","Quarterly","Semi-Annual","Annual" which only allows once choice

Ultimately I want these choices to trigger additional record entries which could be used and input done on a form from these. The use of the Duplicate Command Button seems a bit slow for this as for monthly you would have to do it 12 times for example.

What I need to do to be able to have these Group items trigger Check box selections. For example, If I check the monthly button I need to have check boxes showing an "X" for all Months of the year, Quarterly button for 4 months, etc. These Monthly Check Boxes will be located lower on the form. If no selection all check boxes are null or empty. Each would start from a previously entered date on the form. For example, if quarterly picked and date was 3/1/04 then months March, June, September and December would be the check boxes marked.

Does this make sense

 

[Van T. Dinh]

You can use VBA code in the OptionButton_AfterUpdate Event to change the
values (True/False) of the CheckBoxes.

I am not sure of your set-up of data and the Form but it sounds a bit
complicated.
Perhaps, you should look sample Forms in your Access books or the NorthWind
database.

--
HTH
Van T. Dinh
MVP (Access)

Would what be the best way to do the following?

I want to use an Option Group with choices of

"Monthly","Quarterly","Semi-Annual","Annual" which only allows once choice.

Ultimately I want these choices to trigger additional record entries which

could be used and input done on a form from these. The use of the Duplicate
Command Button seems a bit slow for this as for monthly you would have to do
it 12 times for example.

What I need to do to be able to have these Group items trigger Check box

selections. For example, If I check the monthly button I need to have check
boxes showing an "X" for all Months of the year, Quarterly button for 4
months, etc. These Monthly Check Boxes will be located lower on the form.
If no selection all check boxes are null or empty. Each would start from a
previously entered date on the form. For example, if quarterly picked and
date was 3/1/04 then months March, June, September and December would be the
check boxes marked.

 

[Brian Dehning]

Definitely is probably complicated but I need some guidance to get me started.

This may sound dumb but how do I use VBA code? How and where do I place it? Do I go to properties of the option group or each individual option button?

 

[Van T. Dinh]

You will have to look up Access book and Access book. This is simply too
long for me to type.

--
HTH
Van T. Dinh
MVP (Access)

Definitely is probably complicated but I need some guidance to get me started.

This may sound dumb but how do I use VBA code? How and where do I place

it? Do I go to properties of the option group or each individual option
button?

 

[Brian Dehning]

What is Access Book

Thank you for trying