Visible controls on next form

N

Nigel

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?
 
M

Marshall Barton

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.
 

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

visible controls 2
Hiding Control BAsed on Check Box 4
Managing Visible Property of Label Control 3
VBA works in orignal but fails in copy of database 1
CONTROL PROPERTIES VISIBLE = NO (HIDING CONTROLS) 5
Form set the Visibility of a Label in a Report? 6
Visibility same as previous record 2
Access 2010 Visible Property having no effect 1

Top