Option Group within another Option Group?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want my form to have two "nested" option groups. The first option is
"Existing Employee" and the second option is "New Position". If the first
option is selected, I want additional information to appear that allows the
user to put in a desk location number. If the second option is selected, I
want the user to be able to select the date that the new position has been
budged for (i.e., 2005, 2006, 2007, etc.)

It would be nice if the detail information below each option (desk number,
or date position is budgeted for) doesn't appear unless their relevant
"first" option has been selected. Does that make sense?

I tried an option box with the two options "Existing Employee" and "New
Position", but when I added the dates under "New Position", I didn't know how
to link that to ony the "New Position" Option.

Any help is greatly appreciated!

K -
 
kleivakat said:
I want my form to have two "nested" option groups. The first option is
"Existing Employee" and the second option is "New Position". If the first
option is selected, I want additional information to appear that allows the
user to put in a desk location number. If the second option is selected, I
want the user to be able to select the date that the new position has been
budged for (i.e., 2005, 2006, 2007, etc.)

It would be nice if the detail information below each option (desk number,
or date position is budgeted for) doesn't appear unless their relevant
"first" option has been selected. Does that make sense?

I tried an option box with the two options "Existing Employee" and "New
Position", but when I added the dates under "New Position", I didn't know how
to link that to ony the "New Position" Option.

Any help is greatly appreciated!

K -
Click to expand...

Use the AfterUpdate event of the option group to carry out an action. In
your case it may be to make a combo box visible that includes the date that
the user can select. Something like:

Private Sub optYourOption_AfterUpdate()
If Me.YourOption.Value = your value for New Position Then
Me.YourComboBox.Visible = True

You would have to apply this code to the OnCurrent event of the form as well.
 
Back
Top