Create an Option Group & Combo Box

[123dstreet]

I was hoping to create this on a form: have an option group with 2 options. When option 2 is chosen on the form, then a combo box automatically appears, and the user is forced to make a choice. And then have this choice reflected on the report. any advice would be greatly appreciated.

 

[pbaldy]

You would use the after update event of the option group to make the combo visible as desired. Given that the combo being required is optional, I'd use the before update event of the form to test:

http://www.baldyweb.com/BeforeUpdate.htm

 

[123dstreet]

Thanks I will give this a try, I am new to MS Access and have not used very many codes in VB, could you suggest what I might need to use, or where I might find some examples of some? Thank you kindly

 

[SOS]

The option group uses the index of the options as its value. You set the value of the frame to the index of the item you want or check the value to see what the index is to see which one has been selected.

 

[pbaldy]

Here's a primer if you need it:

http://www.baldyweb.com/FirstVBA.htm

In your case, you'd use an If/Then/Else block to test the value of the option group, and set the Visible property of the combo.