DoCmd.GoToRecord , , acNewRec
If Me.NewRecord And Me.CurrentRecord > 1 Then
Me.tbText= DLast("[tbText]", "table")
replace table with the name of your table
in my attached sample i have 2 fields d2 for hijri-date and d1 for DateGreg.
d1 is empty, i want update it evry field with the equivalent date of hijri-date.
any help please.
sorry for my english.