The delete query that I have written, when executed telss me it can't find the parameter.
The variable is on a subform of the Parent form
The sql for the query is
DELETE SkipTraces.SkipTraceId, *
FROM SkipTraces
WHERE (((SkipTraces.SkipTraceId)=[Forms]![MattersFileFrm]![STraceSubform].[Form]![STraceIdFld]));
I'm sure the problem lies with [Forms]![MattersFileFrm]![STraceSubform].[Form]![STraceIdFld
The variable is on a subform of the Parent form
The sql for the query is
DELETE SkipTraces.SkipTraceId, *
FROM SkipTraces
WHERE (((SkipTraces.SkipTraceId)=[Forms]![MattersFileFrm]![STraceSubform].[Form]![STraceIdFld]));
I'm sure the problem lies with [Forms]![MattersFileFrm]![STraceSubform].[Form]![STraceIdFld