Access-How do I make a field appear based on another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to have field appear based on the response to another field.
I am creating a database for scheduling at a hospital and I will need certain
information gathered depending on what service the patient is calling for.
For example, if the response to the service question is psychology, I would
need a field that I do not need for any other service. Is there any way to do
this? Thanks in advance.

HH
 
Hopefully you are referring to a control on your form rather than another
field in a table. You can control the Visibility of a control in the
AfterUpdate event of a control with similar code in the Current event of a
form.

If Len(Me.Control1 & "") > 0 Then
Me.Control2.Visible = True
Else
Me.Control2.Visible = False
End If

Another way to write this is:

Me.Control2.Visible = Len(Me.Control1 & "") > 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-update a field based on input from previous field 0
Access Form - Lock Fields from Editing 0
DATA VALIDATION RULE BASED VARIED ENTRIES IN ANOTHER FIELD 1
auto-populate field based on info entered into other field 0
How to limit list of a field based on another field in the same ta 6
MS Access 2007: Calculated field based on subform: 1
Creating a new form everytime a contact is made 7
Field Required based on another fields value 1

Back
Top