Larry Brister
asked on
MS Access Form lock control
[I have a form (I inherited) with about a kajilion databound controls on it
There is a Check Box that I need to lock based on the value of a different datafield in my record source.
So
chkSuggestJunk needs to be locked when datafield [Submit Stage] = 'Reject Submit'
This is the image of the checkbox properties
There is a Check Box that I need to lock based on the value of a different datafield in my record source.
So
chkSuggestJunk needs to be locked when datafield [Submit Stage] = 'Reject Submit'
This is the image of the checkbox properties
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent
Watch for followup
Watch for followup
If Me![Sumbit Range] = "Reject Submit" then
Me.chkSuggestJunk.Locked = True
Else
Me.chkSuggestJunk.Locked = False
End If
The trick is .. how many places will you need to execute it? Examples are ... Form.Open, Form.BeforeInsert, [Submit Change].AfterUpdate, etc.