Ok, I have a query that is executed when a field is double clicked in a subform
Here is the query
SELECT tbl_incident.Date_of_Incident, tbl_incident.Badge, tbl_incident.Description, tbl_incident.Code, tbl_incident.Comment, tbl_incident.Points, tbl_incident.Drop INTO tbl_previous
FROM tbl_incident
WHERE (((tbl_incident.Badge)=[Forms]![frm_employeelookup]![sfrm_employeelookup]![Badge]))
GROUP BY tbl_incident.Badge, tbl_incident.Date_of_Incident, tbl_incident.Description, tbl_incident.Code, tbl_incident.Comment, tbl_incident.Points, tbl_incident.Drop;
Now this worked perfectly until..... I deleted a form Called Main Screen, Main screen had 2 buttons. 1. to open a form called add incident. The other button opened a form called Employee lookup.
This employee lookup form is where the subform is located. However since I deleted that Main Screen form, when I double click the subform Employee Info it keeps asking for a parameter value. I have no idea what to do.
I have tried rebuilding the Where statement, several times and that has not helped.
Any suggestions?:banghead:
Here is the query
SELECT tbl_incident.Date_of_Incident, tbl_incident.Badge, tbl_incident.Description, tbl_incident.Code, tbl_incident.Comment, tbl_incident.Points, tbl_incident.Drop INTO tbl_previous
FROM tbl_incident
WHERE (((tbl_incident.Badge)=[Forms]![frm_employeelookup]![sfrm_employeelookup]![Badge]))
GROUP BY tbl_incident.Badge, tbl_incident.Date_of_Incident, tbl_incident.Description, tbl_incident.Code, tbl_incident.Comment, tbl_incident.Points, tbl_incident.Drop;
Now this worked perfectly until..... I deleted a form Called Main Screen, Main screen had 2 buttons. 1. to open a form called add incident. The other button opened a form called Employee lookup.
This employee lookup form is where the subform is located. However since I deleted that Main Screen form, when I double click the subform Employee Info it keeps asking for a parameter value. I have no idea what to do.
I have tried rebuilding the Where statement, several times and that has not helped.
Any suggestions?:banghead: