Selecting row using global variable

Question

I am opening a form and trying to fill it with data using a query that contains a global variable. This causes an alert box to pop up, prompting me to fill it with a value because the syntax is wrong somehow obviously. The table is staff and currentStaffMember is the global variable. This code is in a query.

Here is the code:

SELECT *
FROM Staff
WHERE EmployeeID = currentStaffMember;

https://imagebin.ca/v/3Z7LERXZNvnk (image showing record source)

https://imagebin.ca/v/3Z7Lhn9BnJzl (image showing query)

Can you add the code creating the query?

Blue Granny
– Blue Granny

2017-09-03 13:04:59 +00:00
Commented Sep 3, 2017 at 13:04 — Blue Granny
– Blue Granny, Commented Sep 3, 2017 at 13:04

Erik A · Accepted Answer · 2017-09-03 13:41:54Z

1

You can't use global variables set in VBA in normal queries.

You can, however, use TempVars for exactly that purpose.

Set a TempVar: TempVars!currentStaffMember = "John Doe"

Use a TempVar in a query:

SELECT *
FROM Staff
WHERE EmployeeID = Tempvars!currentStaffMember;

answered Sep 3, 2017 at 13:41

Erik A

32.8k13 gold badges48 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Selecting row using global variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related