Opening forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a database for our staff, and have run into a problem. The
form in question allows people to choose from two supervisors, and then
allows them to run different reports, bringing up the information for the
specific supervisor's direct reports. When I use the macros running this
information for one supervisor, everything comes up just right. When I run
them for the other supervisor, I get an "Action Failed" warning, saying that
the Open Report action failed, even though it's drawing from the EXACT SAME
QUERY as the ones that worked. Can anyone tell me why it would do this?
 
Post the SQL statement of the query. (this seems more like a 'query'
question than a tablesdbdesign question)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

Below is the SQL statement of the underlying query to the form in question:

SELECT tblCSA.Login, tblCSA.LastName, tblCSA.FirstName, tblCSA.Location,
tblCSA.Supervisor, tblCSA.Active
FROM tblCSA
WHERE (((tblCSA.Active)=Yes))
ORDER BY tblCSA.LastName, tblCSA.FirstName;
 
I'm stumped. Maybe one of the other readers have run across this...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top