I have been trying and its tearing my nerves. I know it is a simple answer 

but myself and others seem to can't get the answer. I have a big form with 

multiple tabs. I am now creating a report that has certain information a 

customized report if you may. Now I got it pulling all the other data 

except the last one and its a subform to the parent form.



I want to when I select a Permit # say 35



It will have like



John Smith

1532 XZY Street

Detroit, MI 23892



and the problem I have is in the fees they will have several orders:

Fee_TYPE  FEE  ACCT# Quanity  Total

Cake      $10  1111  1        $10

Pie       $15  2222  2        $30



the Subform is pulling from a query and I have all my controls pulling the 

correct information.



But whatever way I have tried to say I want all those fields I either get 

1 row or nothing but errors. Has anyone had a similiar problem and gotten 

an answer? Any suggestion be appreciated. Thanks



linuxjr@o...