View new fields based on data in other fields

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

Guest

How can I get specific fields to pop up on a form only when certain criteria
is entered or selected from other fields?
 
Make the control's Visible property with the data you want to "pop up" = No.
In the After Update event of the control where the criteria is, make it
visible if the condition is met:

If Me.txtSomeControl = 'Whatever your criteria is' Then
Me.txtAnotherControl.Visible = True
End If

You will also have to put something similar in the form's Current event so
records where the field should be visible/hiddend depending on criteria:

If Me.NewRecord Then
Mt.txtAnotherControl.Visible = False
ElseIf Me.txtSomeControl = 'Whatever your criteria is' Then
Me.txtAnotherControl.Visible = True
Else Me.txtAnotherControl.Visible = False
End If
 
Thank you!

Klatuu said:
Make the control's Visible property with the data you want to "pop up" = No.
In the After Update event of the control where the criteria is, make it
visible if the condition is met:

If Me.txtSomeControl = 'Whatever your criteria is' Then
Me.txtAnotherControl.Visible = True
End If

You will also have to put something similar in the form's Current event so
records where the field should be visible/hiddend depending on criteria:

If Me.NewRecord Then
Mt.txtAnotherControl.Visible = False
ElseIf Me.txtSomeControl = 'Whatever your criteria is' Then
Me.txtAnotherControl.Visible = True
Else Me.txtAnotherControl.Visible = False
End If
Click to expand...
 
You must log in or register to reply here.

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

Copy record info into new form 0
How to limit list of a field based on another field in the same ta 6
Access Form - Lock Fields from Editing 0
Can a Check Box Prevent Other Fields from Being Used? 1
auto-populate field based on info entered into other field 0
Form fields don't need to always be filled in 1
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Prompt for Criteria Field When Opening Form 7

Back
Top