Parameter Query, No Promt??

[headintheclouds]

Hi

I have been looking all over the web and have not had much luck.

The problem is that on some machines in the office a parameter query will not run properly. On mine and a couple of other machines the query runs perfect and picks up the right information. On the others, the query runs but there is no promt for the user to enter addtional information and shows a blank recordset. Is there any solution?

Thanks

HITC

 

[boblarson]

Not sure why, but you could check for MISSING References. Also, I prefer to use a form to ask for parameter input as I can set the form to accept only validated information and also it displays to the way I want it to display. It might actually help in this case too, but that's only a suggestion.

 

[headintheclouds]

Thanks for replying ...did the above but still no joy

Below is sql view of the query that I am running, I wonder if you can see something that I can't

SELECT tblCorrectiveActionLog.[Audit Number], tblCorrectiveActionLog.CARRef, tblAuditInformation.[Lead Auditor], tblAuditInformation.[Date Of Audit], tblAuditInformation.[Area Of Audit], tblCorrectiveActionLog.Comments, tblCorrectiveActionLog.[Action Taken], tblCorrectiveActionLog.[Person Responsible For CA], tblCorrectiveActionLog.[Complete CA By], tblAuditInformation.[Procedure Audited], tblAuditInformation.[Procedure Audited 1], tblAuditInformation.[Procedure Audited 2], tblAuditInformation.[Procedure Audited 3], tblCorrectiveActionLog.[Suggested Action]
FROM tblAuditInformation INNER JOIN tblCorrectiveActionLog ON tblAuditInformation.[Audit Number] = tblCorrectiveActionLog.[Audit Number]
WHERE (((tblCorrectiveActionLog.CARRef)=[Forms]![frmAuditInformation]![frmCorrectiveActionLog]![txtCARRef]));

The above that I have highlighted seems to be the problem, if I remove this or change to look at another textbox it works. I don't understand why the same database run on my machine the above works but on others it works but with no recordset

 

[headintheclouds]

Please somebody help!!

 

[boblarson]

Well, after looking at it again, I'm not sure why it would work on one machine as the Where clause as written should make it error out on any machine. The Where clause SHOULD be written
If txtCARRef is text:

WHERE (((tblCorrectiveActionLog.CARRef)='" & [Forms]![frmAuditInformation]![frmCorrectiveActionLog]![txtCARRef] & "'));"

and if it is a number it should be:

WHERE (((tblCorrectiveActionLog.CARRef)=" & [Forms]![frmAuditInformation]![frmCorrectiveActionLog]![txtCARRef] & "));"

 

[headintheclouds]

Again thanks for replying but I did figure it out, it was due to the the fact that the machines that worked had office service pack 2. I have updated the other machines and they are now working fine but thanks for all your help

 

[boblarson]

Glad to hear - it's always a pain when something works on one and not on another. That's one of my "love/hate" relationship issues with Access