For example on record 1, field1's value is "records" and field2's enabled property is set to false. When I go to the next record (record 2), field2's enabled property remains set to false even though field1's value is now "measurable" which should make field2's enabled property as true. Here's the code I have right now:
Expand|Select|Wrap|Line Numbers
- Private Sub Field1_AfterUpdate()
- Me.Field2.Enabled = True
- If Me.Field1 = "records" Then
- Me.Field2.Enabled = False
- ElseIf Me.Field1 = "measurable" Then
- Me.Field2.Enabled = True
- End If
Thanks!