Update a field from another table field only for new records
I am stuck with updating a field record with a field from another table.
I have two different forms.
Form 1:
DateId(AutoNumber & PrimaryKey)
SelectDate (Date/Time, Format "Short Date")
DateChanged (Date/Time, DefaultVaule= "Date()")...