subforms

[Guest]

I have two subforms on the same tab. Both of them use the same table. They
are supposed to be linked to each idividual contact in the database. Each
time a new line is made in the first subform when I click on the notes form
in the second subform (this is the only field in the second subform) I get
the error message: You tried to assign the Null value to a variable that is
not a Variant data type. (Error 3162). How do I fix this error? Please let
me know either here or at (e-mail address removed).

Thanks

 

[Arvin Meyer [MVP]]

My guess is that you are not properly linked to your foreign key in the
underlying table of the subform. Since the field is required, you're getting
the complaint about the Null. Instead of using 2 separate subforms, try
using a single one, or use 2 tables, so that you have a Key in each one of
them.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

It worked in Microsofts free database "Contact Management Database" that you
can download from their site.....check it out and let me know if I can repair
it. I dont want to create a second table if I dont have to.

Thanks,

Nathan

 

[Arvin Meyer [MVP]]

The underlying recordsource of the database has 3 fields, not 1. And the
link from the Notes subform connects to the Call List Subform. As I
suggested before, you are probably not linked correctly.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access