Sub subform, improper use of null (1 Viewer)

[cright99]

I have a form (shown in the picture) that has a sub form and a sub subform. Im woundering what is the best way i can add a record in the subform so i dont get the error "You tried to assign the null value to a varable that is not a varant data type" when the user tries to add a new record straight on the sub subform . I have done it different ways but still not as well as what i would like. Ive been looking around as i would of thought this error would be common. But not luck.

Thank you!

 

[JANR]

Take a look at this tread: http://www.utteraccess.com/forums/printthread.php?Cat=&Board=88&main=534059&type=thread It may be the answer to you are looking for.

JR

 

[cright99]

Thanks for the reply. The link was very interesting and gave me some new ideas to try out. Cheers