Variable?

[vivian]

" You tried to assign the Null value to a variable that isn't a variant data type"


This is the message i get when i try to enter data into my form.
Here's the background.

I used the wizard to split my table into 5 tables. I re-did my form to include subforms. The main form is called table 1. Subforms that are within this form are main bldg, door 1, door 2, etc.

Now when i go to add data to the form, when i enter data into the subforms i get this message
" You tried to assign the Null value to a variable that isn't a variant data type"

I've searched, and I've looked and read the help from access and I can't figure this one out.

Please Help

 

[Jack Cowley]

Are you sure your links are correct between subform and form? Can you add data directly to the related 'many' table? (I assume the relationship between your main table and Bldg and Door tables are one to many.) Also, tables Door1 and Door2 sound like they should be in one table called Doors, or whatever and should not be separate fields. Something like this:

tblDoors
DoorID (PK)
MainTableID (FK)
DoorName
...other fields...

hth,
Jack

 

[vivian]

The door tables are actually Door end tables. The buildings can possibly have 2 different types of door ends with about 12 different options each, that's why I put them in two different tables.

Yup, the main table and subforms are connected properly according to the link info.

I think I'm just going to put it all together in the same table again and make up my report manually (w/o the wizard). Or do you think this might cause more problems down the road?

Any other ideas are much appreciated.


thanks

 

[Jack Cowley]

Hmmmm. It is hard to know if your tables are normalized or not, but if sounds like you should have a table for Doors and a lookup for the type of door it is. And the 12 options should be a look up as well. Without seeing your tables it is hard to know if you have them properly normalized so it is hard to guess just what is going on...

Jack