Recent content by bmac

Thanks - but a split form is not a subform - or is it? I have searched all over and cannot find any reference to filtering a Access 2007 Split form. Bill

Is it possible to create a split form where the split part of the form is filtered showing only those fields of a member defined by a combobox control in the parent part of the form? Bill

Adam, For some reason I get a Type Mismatch error (13). Why would this be. The VBA code, slightly modified is: Dim amtcost As Variant mydate = Forms![Medical]!VisitDate xprovider = Forms![Medical]!Provider amtcost = DLookup("sumamt", "qry_transSumByDate", "[tdate] =" & mydate And...

Thanks for the fast reply! The two criteria - the AND statement - was what was giving me trouble. Thanks again. Bill

I am a beginner-intermediate trying to understand how to extract data from a simple query. The query fields are vdate, provider, sumamt. Using VBA during a click event I want the code to get sumamt where vdatedate=form![medical].visitdate and provider=form![medical].provider. SumAmt would be...

Thanks! Yes, I tried that and it did not have any effect - although since I am a relative newbie (compared to you guys), I may have done something wrong in the properties sheet. Bill

Thanks Guys. It is now working properly. I think I need to study functions some more! Bill

Thanks. But I must still be doing something wrong as the empty fields still must be populated with a 0. My formula is.... =nz([Cost1]+[Cost2]+[Cost3]+[Cost4]) Bill [submitted before I saw the post from Missinglinq - now will try that]

I have a simple textbox called TotalCost with the formula =cost1+cost2+cost3+cost4. The cost fields are table fields. The table fields are set with the format as currency. I have found that if one of the fields does not have any value in it, the formula won't calculate. If I put a 0 [zero]...