Frothingslosh
Premier Pale Stale Ale
- Local time
- Today, 07:59
- Joined
- Oct 17, 2012
- Messages
- 3,276
You can simplify that with this:
Nz does what your entire if statement is trying to do, with less effort and processor cycles.
Code:
Private Sub TF_Ben_O_P_Click()
Me.TF_Ben_B_S_Date.Value = Nz(TF_Ben_B_S_Date, Now())
End Sub
Nz does what your entire if statement is trying to do, with less effort and processor cycles.