Hello all, i have a students form which contains all student information etc.

On this form i have a selection box which allows the user to choose if the student is SEN. If selected i want a combo box to appear linking to the SENType list. If not selected i don't want the combo box to appear.

Selection box named: CheSEN
Combo box: CboSENType

Not sure what to do

THanks

By "selection box" named CheSEN, are you talking about a checkbox? If so, you could try something like:

Private Sub CheSEN_AfterUpdate()
Me.CboSENType.Visible = Me.CheSEN
End Sub

Hope that helps...

Thanks that works. But i was wondering what would i add so that it werent visible on form load if its not ticked?

Edited by: nhagan on Thu Nov 12 13:06:31 EST 2009.

Hi,

In the Form's Current event, you could try this:

Private Sub Form_Current()
Call CheSEN_AfterUpdate()
End Sub

Hope that helps...

Thank you very much!

works perfectly x

You're welcome. Good luck with your project.