Viewing Records if no subform info is present

[FlashG]

I have a Task form that has a subform Parts. When I want to show all records or do any sort of filters it will not show those records that do not have any parts associated with them. Some task are jsut action tasks and have no parts. All the Tasks that have at least one part in the part table show up fine. How do I show those action tasks?

Also, on this form I can add parts via the subform but I am unable to change anythign on the main form. It is based on a query that has the Tasks table and two totals fields. The only way I can edit at the moment is to call up a form that is based soley on the Tasks table without the totals. Is there a way I can edit on the fly with a table based on a query with totals?

 

[FlashG]

Ok, I think I got what you are saying, but how do I display this control on the main form? I tried setting the control on the main form to =Sum([subform].[hours]) but that didnt' work and I couldn't find a way to set it = to that control...

 

[Rich]

Since your new field in the subform has the Sum you don't need to do it again. Just set the control on the main to reference the sub
ie. =Forms!MainFormName!Subform Name subform.Form!ControlName
HTH