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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top