Windows 10
Access 2007
I have 2 fields on a form
1. txtIn_Stock
2. txtIn_StockChangeDate
I am trying to achieve that when field 1. txtIn_Stock changes then Field 2. txtIn_StockChangeDate enters todays date.
I am using the code below but no joy so far.
Grateful if anyone can help.Code:Private Sub txtIn_Stock_BeforeUpdate(Cancel As Integer) Me.txtIn_StockChangeDate = Date End Sub