Option Group

[EmmaJane]

Okay I'm sure this is straight forward and believe me I have searched for an answer but I think my problem is that I don't know what to search for!

I have a form and on this form I have a list box with three choices, Pending, Accepted and Rejected... What I would like is when they choice Rejected that an option group appears and they must check one of these.

Any help would be greatly appreciated

 

[Mile-O]

If Me.MyListBox = "Rejected" Then
    Me.MyGroup.Visible = True
Else
    Me.MyGroup.Visible = False
End If

 

[EmmaJane]

Thanks for this I have had a look but I'm not entirely sure were to put it

 

[Mile-O]

In the AfterUpdate event of your listbox.

 

[maxmangion]

you can try to put it on the AfterUpdate of your listbox

 

[dt01pqt]

Thanks for this I have had a look but I'm not entirely sure were to put it

On the listbox change event:

[COLOR=Red]Private Sub MyListBox_Change()[/COLOR]
If Me.MyListBox = "Rejected" Then
    Me.MyGroup.Visible = True
Else
    Me.MyGroup.Visible = False
End If
[COLOR=Red]End Sub[/COLOR]

On the form create an option group called MyGroup and make it invisible.

 

[dt01pqt]

dope thinking about combo's

 

[EmmaJane]

Okay got it now thanks for the help was putting it there but had spelt something wrong, must remember always check the obvious first!