Search results
-
B
Split Form
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 -
B
Getting data from query in VBA
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... -
B
Calculated field on Form will not calculate if a null value is present
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]...