View Full Version : form design


Matze
11-21-2001, 05:36 AM
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
11-21-2001, 06:02 AM
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
11-21-2001, 07:04 AM
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.