J
jdamon1
I have a form where I am passing the user log on from the previous
form. I want to load the next form based upon the User ID. I passed
the variable over and the statement works but if I log out and log on
as a different user the first user data shows up. Then if I log out
and log back in as the second user again it works. Here is my code.
Dim UID As String
UID = GetTagFromArg(Me.OpenArgs, "value")
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As String
Dim strCriteria As String
Dim strSQL As String
Set db = CurrentDb()
Set qdf = db.QueryDefs("que_Sales_rep")
db.QueryDefs.Refresh
strCriteria = "'" & UID & "'"
strSQL = "select * from [SAL_Sales Tracking Data] where [SAL_Sales
Tracking Data].[Assigned To] =(" & strCriteria & "); "
qdf.SQL = strSQL
Set db = Nothing
Set qdf = Nothing
Can anybody help me out.
form. I want to load the next form based upon the User ID. I passed
the variable over and the statement works but if I log out and log on
as a different user the first user data shows up. Then if I log out
and log back in as the second user again it works. Here is my code.
Dim UID As String
UID = GetTagFromArg(Me.OpenArgs, "value")
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As String
Dim strCriteria As String
Dim strSQL As String
Set db = CurrentDb()
Set qdf = db.QueryDefs("que_Sales_rep")
db.QueryDefs.Refresh
strCriteria = "'" & UID & "'"
strSQL = "select * from [SAL_Sales Tracking Data] where [SAL_Sales
Tracking Data].[Assigned To] =(" & strCriteria & "); "
qdf.SQL = strSQL
Set db = Nothing
Set qdf = Nothing
Can anybody help me out.