.adp ms access store a value

axcess2
axcess2 used Ask the Experts™
on
I have written code to audit user usage in the project in adp project, sql server

the code runs on load events of forms

call auditusage(strSessionID,GUID, myInt, myString)

what I need i many cases is for GUID, myInt, myString to be the last GUID, myInt, myString in table AuditUsage

How can I store a value
If on load of frmPatients , GUID = 123
can I store it and call it later after frmPatients is closed?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
Last has no meaning in a relational database.  Do you mean maximum?
Simply create a global variable in a module. Global variable remain available to all modules and forms.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial