Form Problem

[generically]

I have created a form with 3 tab subforms. But for some reason when I go to enter data in the subform I get the error message of "You have tried to assign the Null value to a variable that is not a Variant data type". This doesn't happen when I open the subforms individually however.
Any hints on what I have done?

 

[Joe4]

I had something like this happen a long time ago, and my memory is a bit sketchy, but maybe I can give you a few ideas.

It might have something to do with how the tables are related and the Key Fields. I once was trying to add new data, and it was trying to add related records in the linked tables, but didn't have all the key fields necessary to do so.

You may also want to check if you have Cascading Upddates and Cascading Deletes checked in your Relationships between the tables. Playing around with these may help.
This message was edited by jmiskey on 2003-02-20 15:48

 

[parry]

Hi, I dont know enough about this but there is some link between the subform and the main form - Child and Master field links? Maybe theres something wrong with that link.

If it were me I would delete the subform and redraw it again on the main form to take that out of the equation when trying to find the problem. The wizard that kicks in when you add a subform does all the linking for you.