form design

[Matze]

Hi,
is it possible to create text boxes within a form which only show up, if a certain value in another text box is choosen?

EG:
1st choice
Class: Access

New text box shows up:
Previous experience with access: Beginner

Thanks a lot for your help!
Matze

 

[ian_ok]

Set THE OTHER FIELD to not enabled in properties first then add this code to the one they will first enter data into.

Private Sub YOURFIELD_Change()
If Not IsNull(Me.YOURFIELD) Then
Me.THE OTHER FIELD.Enabled = False
Else
Me.THE OTHER FIELD.Enabled = True
End If
End Sub

Ian

 

[jwindon]

Read the question differently than Ian...

You need to add code to the control box..I would say....OnChange event......

If Me.FirstTextBoxName = "Access" Then

Me.SecondTextBoxName.Visible = True

Else

Exit Sub

End If


The visibility of the second text box should be set to NO in its properties.