Maintaining USERID from form to form after INITIAL capture of ID

[RuralGuy]

TempVars started in Access 2007


https://blogs.office.com/2010/09/27/...2007-and-2010/

[msaccesspat]

Hi Perceptus, I looked up tempvars and was ready to implement, thanks for idea. In doing so, and relooking at code I was setting the SQL field name (UPDTOPERID) equal to the textbox name (txtuserid) which was on the parent form. I had to use the GLOBAL variable name struserid in the module instead. I believe that was my problem. I tested several times ,and it is now working. I have to continue to test on other all other subforms but I learned something here

thanks to you and RuralGuy who spent much time with our dialog.

"learning is a process" !!

[RuralGuy]

Excellent! Thanks for posting back with your success and solution.