Hi pals, I have a form containing a field Pdate. I would like to populate a column "PrintDate" in the Emp_table table with the same value at Pdate.
I have tried
1.
Private Sub txtPdate_AfterUpdate()
Me.txtPdate.Value = PrintDate
End Sub
2.
Private Sub txtPdate_AfterUpdate()
strSQL = "UPDATE Employee_table SET [PrintDate] = Me.txtPdate.Value
End Sub

3.
Private Sub txtPdate_AfterUpdate()
PrintDate = Lookup(txtPrintDate.Value)"
End Sub

I have used the AfterUpdate() because the Pdate field is populated via three combo boxes day, month and year. Your help will greatly be appreciated.