Solved Saving a TempVars from a table value based on logged in user (1 Viewer)

mamradzelvy

Member
Local time
Today, 22:55
Joined
Apr 14, 2020
Messages
145
Hello,
I have made a second post regarding this and more here.
I just want to ask seperately in a diferent Forum section as i'm not sure i chose the right one before.

I would like to save a TempVars value based on a column in my account table, but i don't know how to pull that data from there based on the login input.

I currently use TempVars from the login screen, which goes like this:
C#:
TempVars("UserName").Value = Me.txtboxname.Value
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:55
Joined
May 7, 2009
Messages
19,169
you can save the tempvars to a table using Query, provided that the Tempvar was already
created prior to saving to table.
 

mamradzelvy

Member
Local time
Today, 22:55
Joined
Apr 14, 2020
Messages
145
Thank you @arnelgp but that's not really what i was trying to do, i was attempting to create the tempvars based on a table instead of just a txtbox.
Which i ultimately achieved using a recordset like this

C#:
Dim rs As Recordset



Set rs = CurrentDb.OpenRecordset("tablename", dbOpenSnapshot, dbReadOnly)



TempVars("FullName").Value = rs!column_name.Value
 

Users who are viewing this thread

Top Bottom