Visible controls on next form

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

Guest

I ahve a form which allows me to selecta day of the week and as a result two
other controls are greyed out.

Private Sub Performance_AfterUpdate()
If Me!Performance = "Tuesday" Then
Me!Concessions.Enabled = False
Me!ConcessionRate.Enabled = False
Me!AdultRate = 9
Else
Me!Concessions.Enabled = True
Me!ConcessionRate.Enabled = True

End If

End Sub

The trouble is that when Tuesday is selected, the two greyed out controls
appear greyed out on the next entry. can they automatically be visible when
going to the next record?
 
Nigel said:
I ahve a form which allows me to selecta day of the week and as a result two
other controls are greyed out.

Private Sub Performance_AfterUpdate()
If Me!Performance = "Tuesday" Then
Me!Concessions.Enabled = False
Me!ConcessionRate.Enabled = False
Me!AdultRate = 9
Else
Me!Concessions.Enabled = True
Me!ConcessionRate.Enabled = True

End If

End Sub

The trouble is that when Tuesday is selected, the two greyed out controls
appear greyed out on the next entry. can they automatically be visible when
going to the next record?
Click to expand...


You need the same (or similar) code in the form's Current
event.
 
Back
Top