[AccessD] Northwind 2007 question

[Arthur Fuller]

Since I don't have v. 2010 or beyond, I don't know whether the Northwind
sample application has changed. The 2007 version has changed considerably,
in terms of user interface, from previous versions. Most immediately
apparent is the lack of a starup form that functions as the app-menu.
Instead, the opening form resembles a dashboard, with relevant information
and action-items presented at once.

Actually, the opening screen is a login form, followed immediately by the
dashboard. This form contains a couple of subforms, one of which is a
datasheet listing active orders for the current user. The datasheet is
based on a SELECT statement, but the SELECT makes no mention of the current
user. I'm not seeing how this query is restricted to the current user, but
somehow it is. I know this because when I grab the SELECT statement and run
it as a query, I get the active orders for all users, not just the current
one.

Has anyone familiar with this sample app got an idea how this is achieved?
Perhaps it has something to do with the Parameters table?

-- 
Arthur