NearImpossible
Registered User.
- Local time
- Today, 00:31
- Joined
- Jul 12, 2019
- Messages
- 225
I have an access query built to pull a record from a SQL linked table, if it matches a value from a local table, however when I run the query, I am promted with Enter Parameter Value db_CurrentUser!UserName, which is the name of my local table and value I am trying to match.
If I manually enter the value that is sitting at db_CurrentUser!UserName, the query works, but it doesn't seem to find it on its own.
Any thoughts?
If I manually enter the value that is sitting at db_CurrentUser!UserName, the query works, but it doesn't seem to find it on its own.
Any thoughts?