I want the field [OWNERS CONSENT] to be visible and editable only when the field [LI or DA Status]="DA".
(Both fields are in the same table)
I did try and use VB by doing the following.
I would right click the field [OWNERS CONSENT], build code followed by code builder.
Then I would type in the following,.
Private Sub OWNERS_CONSENT_AfterUpdate()
If [LI or DA Status]="DA" = True then
[OWNERS CONSENT].Visible = True
Else
[OWNERS CONSENT].Visible = False
End If
End Sub
This was unsuccessful, and ideas appreciated?
Can I do this as Access function or do I need to use Visual basic.
(Both fields are in the same table)
I did try and use VB by doing the following.
I would right click the field [OWNERS CONSENT], build code followed by code builder.
Then I would type in the following,.
Private Sub OWNERS_CONSENT_AfterUpdate()
If [LI or DA Status]="DA" = True then
[OWNERS CONSENT].Visible = True
Else
[OWNERS CONSENT].Visible = False
End If
End Sub
This was unsuccessful, and ideas appreciated?
Can I do this as Access function or do I need to use Visual basic.