You tried to assign the Null value to a variable that is not a Var

  • Thread starter Thread starter Xfree
  • Start date Start date
X

Xfree

I started to get the below error message when I try to add a record in a
sub-form field.
You tried to assign the Null value to a variable that is not a Variant data
type. (Error 3162)

I have read the "help" page on this but I have not gotten this before on the
same sub-form so I must have changed something.

Any ideas?
 
Do you have a Master-Child relationship between the main form and the
subform? or have you set the subform to filter on the value of a control in
the main form?

My first guess is that your subform is filtered, not built in the
master-child relationship, and you have tried to save the record without
filling in the foreign key field.
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Back
Top