Extra ')' in query Expression

[lzook88]

I am getting an error when I change a combo-box.



The coding is set up to find all certifications that pertain to that userid

when i change the user id and click on the drop down for the certifications it gives me and error

Extra ) in query expression '(((qryCerts.HashID)=))'.

and the code it is looking at is:

Me.Certification.RowSource = "SELECT DISTINCTROW qryCerts.ID, tblCertificationTypes.CertType, qryCerts.CertNum, qryCerts.Issued, qryCerts.Expiration, qryCerts.HashID, tblCertificationTypes.CertType_ID " & _
"FROM tblCertificationTypes INNER JOIN qryCerts ON tblCertificationTypes.CertType_ID = qryCerts.Certification " & _
"WHERE (((qryCerts.HashID)=" & Me.Combo31 & ")) " & _
"ORDER BY tblCertificationTypes.CertType;"

If I type in the username to get it to populate it gives me the error and then if i hit okay on the error message and select a user name, it begans working with out issue.

but if i select it from the list, i dont get an error.


thanks for the help

[June7]

None of the parens are necessary but should not cause error. I think you would still get error message if the parens are removed. Something else is true issue. The error message doesn't show any value from the combobox.

Would need to examine combobox properties and code to determine exactly what.

Why are you changing the combobox RowSource? Could just set the RowSource property to the SQL statement and then code just has to requery the combobox - only don't use the Me reference.

[lzook88]

It is because I have the code in CHANGE not in LOST_FOCUS .. so each letter i type, it looks for it one letter at a time! with lost focus. it waits until i tab off or click out side the combo box to update the next combobox

[pbaldy]

I would use the after update event rather than lost focus; you really only care if the user changed something, not if they just tab through. Also, as you note the change event fires with every keystroke, so it is rarely needed. When it is, you need to use the .Text property of the control to get the value being typed in. That's likely why there's no value in your error message.