How to send a VAR to table on save - Please help me URGENT

[najathsl]

Hi Guys,



I have a VBA module with a PUBLIC Variable "STR_VAR" to save the user ID to table on every Transaction,

can any one please tell me how to send my VBA variable to table on auto save of a form.

please guys, sorry if this topic is already being covered in the forum.

Kind Regards
Najath

[NoellaG]

Hi,

you can write a function to retrieve the variable, and then, for example write in the before update event of the form:

me.txtUserID = MyRetrievalFunction()

[najathsl]

Hi,

Thanks alot for your reply, i am trying but still i am lost.

Najath