Enter Parameter Value error when Hit Close button on XP

C

Charles Anh

I created query to call user rights and the ability to
update certain project based on their rights. Some of
the XP machine in the lab I am getting "enter parameter
value" errors when I click on the Close button i created
in the form. Why am i getting this error message on some
XP machine and not on all. I know my query/form is good
because it is working on some XP machine. Please Help.
Here is my query.

SELECT tblProjects.ProjectID, tblProjects.ProjectNumber,
tblProjects.ProjectName, [forms]![frmprojectionbyPerson]!
[txtUserRights] AS Expr1
FROM tblProjects
WHERE (((tblProjects.ProjectDirectorID)=[forms]!
[frmprojectionbyPerson]![txtuserID]) AND
((tblProjects.flgClose)<>-1)) OR ((([forms]!
[frmprojectionbyPerson]![txtUserRights])="All") AND
((tblProjects.flgClose)<>-1))
ORDER BY tblProjects.ProjectNumber;


Charles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top