I’ve also tried nicotine pouches here and there, but they never hit quite the same for me. I get why people like them, though—discreet, no smoke, and easier to use in public.
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.
i use this code, for eatch field i want to have in new record
DoCmd.GoToRecord , , acNewRec
If Me.NewRecord And Me.CurrentRecord > 1 Then
Me.trib_jug = DLast("[trib_jug]", "tbl1")
end if
i use this code for concatenate 2 fields in my report
CODE
=[name] & " - " & [price1]
it works fine, my only problem is i can't see the symbol money in my texte boxe on my report like "book - 500.00$"
any help.
sorry for my bad english