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

[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?

 

[Dale Fye]

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.

 

[Xfree]

Yes it was a master child issue works now!

Thanks Dale

Mark