Issue with Form/Query/Report

[KristenD]

I have a query that I created that I'm using for a form and a report.

The first time I tried it, it did what it was supposed to do. Now, it does not bring up any records. What did I do wrong?

Here is the query:

SELECT tblEmp.EmployeeID, tblEmp.EmployeeName, tblEmpCert.CertID, tblCertification.Certification, tblEmpCert.CertDate, tblEmpCert.CertExpiration, tblEmpCert.State, tblEmpCert.CertNumber
FROM tblEmp INNER JOIN (tblCertification INNER JOIN tblEmpCert ON tblCertification.CertID = tblEmpCert.CertID) ON tblEmp.EmployeeID = tblEmpCert.EmpID
WHERE (((tblCertification.Certification)=[Forms]![Certifications]![cboCerts]));

Thank you!!

 

[KristenD]

I figured out my issue with the query/form/report.

I do have another question. How do I get the form to reset?

I did put a button in the form to get it to refresh all data but it still has the previous information in the combo box. Is that normal?

DOes something else need to be done?

Thank you!