G
Guest
I have code in the afterupdate event to enable certain fields when a
condition is met. How do I limit the rule to apply the current record/row
only as it seems to apply to all other records on the datasheet.
If the current row has a withdraw date it will enable the withdraw reason
field for all other rows as well as the current row.
The code is
If Me.dtWithdrawdate <> "" Then
Me.txtWithdrawreason.Enabled = True
Me.txtWithdrawreason.SetFocus
Else
Me.txtWithdrawreason = Null
Me.txtWithdrawreason.Enabled = False
End If
condition is met. How do I limit the rule to apply the current record/row
only as it seems to apply to all other records on the datasheet.
If the current row has a withdraw date it will enable the withdraw reason
field for all other rows as well as the current row.
The code is
If Me.dtWithdrawdate <> "" Then
Me.txtWithdrawreason.Enabled = True
Me.txtWithdrawreason.SetFocus
Else
Me.txtWithdrawreason = Null
Me.txtWithdrawreason.Enabled = False
End If