Search results

It was suggested to me to build a named macro that reference tempvar, but my problem is I don't know how to build a named macro that reference tempvar and I don't know how to call it from data macro either, I would really appreciate it if someone shows me an example of how to do that

I am using tempvar because I store the current user name in it.

I am not sure if they can reference a textbox, but even if they could that would mean I will have to update every form, that really defeat the purpose of using data macros. Data macros are used at the table level independently from and form, report or vba code

I could, but data macro are much more easier (at least for me) in what I am trying to achieve, I could write some vba code, but that would set me back a few weeks, I hope someone else knows how to do this and show me an example

I want to create a data macro on a table in my database that is triggered by the after update event and writes the content of a TempVar object in a field in another table. When I want to use the data macro to write something else then a TempVar Object I do the following: If...