Bob - I just tested something that may give us insight. If I open the sub form seperatly, then open the main form, then the formulas work. If I open the main form by itself, even though the sub form is included in the main form, the formulas don't work. Why is this? How can I fix it?