SUM VALUES FROM FORM AND SUB 1

[shelron]

I am trying to sum two different fields and then add them to a table.

the form has a one, and a sub, many side


I want to take the value of textbox1 from the main form, and sum it with the value from textbox2 on the subform,

then have an event that updates textbox3 on the main form, thus updating the table.

I keep getting an error "invalid use of null"

Essentially, if the sub contains no data, I get the error.

 

[930driver]

It's hard to say where your problem lies without seeing your code, but you might try looking up help on the Nz() function which converts nulls to zero. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[shelron]

=([value1]+[RtblEquipmentAccessories subform]![TEXT13])


I have this function set on the control source of a text box, It works fine if I have values in the one and the many side of the tables,

but if I have no corresponding record on the subform, it returns nothing.

 

[930driver]

Try this:

=([value1] + Nz([RtblEquipmentAccessories subform]![TEXT13]))

This will convert the null value to a zero. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[shelron]

You da man!

thanks very much,,

Ron