Appearing check box!

[spcepickle]

I have a form with a drop down menu. If the user selects "school" from the drop down menu I would like for a check box to appear.

Thanks for any help you can give me!

~Amelia

 

[Zerothi]

Use the VBA

Hi Amelia

One idea is to make a macro in the VBA editor then do something like this:

Private Sub drobDownName_AfterUpdate()
Dim checkString As String
checkString = "School"
If Me.drobDownName.Value = checkString Then
'this is where you make you checkbox visible
Me.checkBox.Visible = True
End If
End Sub

Hope this helps

 

[missinglinq]

Putting unnecessary steps in is an invitation for problems! Keep it simple whenever possible:

Private Sub ComboboxName_AfterUpdate()
If Me.ComboboxName = "School" Then 
  Me.YourCheckBox.Visible = True
End If
End Sub

 

[gemma-the-husky]

and you possibly need the same thing in the current event, to initiate the position when you view a previously entered record

 

[missinglinq]

Gemma's correct, of course, unless this is a form to input criteria for searches or running queries or reports. If you want the checkbox on a given record to be visible/invisible as you move from record to record, you'll need to have similar code in the Form_Current event, and either the combobox will have to be bound to the underlying table/query, or the selection from the combobox will have to be assigned to a bound control on the form.

 

[spcepickle]

Thank You! The code worked well.
~Amelia

 

[missinglinq]

Glad we could help!