Format Subform

D

Dave Hawks

I have a subform displaying a list of times and User Names.
When the form is opened I want some times to be enabled and others not based
on a value in the main form.
The following code checks the value on the main form and currently disables
all fields against each time.
I would like an If statement that would only disable the player fields where
TeeTime was between Certain Times e.g Between #09:00:00# and #16:00:00#

If Forms![Competition master Data]![CompCode] = "O" Then
Some if statement to define time range? Then
Forms![Competition master Data]![frmqerTeeTimes]![Player 1].Enabled = False
Forms![Competition master Data]![frmqerTeeTimes]![Player 2].Enabled = False
Forms![Competition master Data]![frmqerTeeTimes]![Player 3].Enabled = False
Forms![Competition master Data]![frmqerTeeTimes]![Player 4].Enabled = False

Can anybody suggest a method
Thanks
 

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

Parameter change using Query 0
Cannot find Form Error 2
Passing a unique ID to a subform 0
Data Entry property keeps setting to False 13
Disable controls on one record (row) of a continuous form 2
Can't assign value error 5
VBA code returns no records hwenKey ID is added 14
Update lookup query in subform 4

Top