M
mscertified
I have a form and a subform. The form record source is tblActivities. When a
combo box value changes the subform records are refreshed. This is done by a
DELETE followed by an INSERT. The puzzling thing is the SQL for the INSERT
refers to tblActivities even though the table is not named in a FROM clause.
Is this valid? It seems like it was working before I made some changes but
now I'm getting "no value given for required parameter" and cannot figure out
what is wrong since it does not tell me which parameter.
combo box value changes the subform records are refreshed. This is done by a
DELETE followed by an INSERT. The puzzling thing is the SQL for the INSERT
refers to tblActivities even though the table is not named in a FROM clause.
Is this valid? It seems like it was working before I made some changes but
now I'm getting "no value given for required parameter" and cannot figure out
what is wrong since it does not tell me which parameter.