May I offer a suggestion.
Define the parameters in your SQL string (or query)
for every field that references something on a form [FIELDNAME] as an example
for instance if you were trying to append the field contents from [FIELDNAME] on your form [MYFORM]
you would have a sql statement like:
Code:
PARAMETERS [Forms]![MYFORM]![FieldName] DateTime;
INSERT INTO tblDocumentSigner ( DS_Date )
SELECT [Forms]![MYFORM]![fieldname] AS Expr1;
Sometimes Access can't interpret whether a text box is meant to be a date, a number, text and will throw that parameter error, if you define the field in your parameters it should work fine.