Search results

  1. N

    Open form with macro

    I created a macro I thought would look at the field after I selected the option "credit card" from a drop down list then open the form "Credit Card Info" so I could fill in the credit card information. The macro works but I have to put in the words "credit card" in the "enter parameter value"...
  2. N

    Bound Text Box

    =Sum([PymntSmry Rpt].Report!PymntAmnt) I used the expression builder to create this expression on the main report to return a calculated value from a subreport, but it doesn't work. I tried to do a search on this web site to see if I could find a similar threat but didn't have any luck. If...
  3. N

    IIF function

    =IIf([Bond Cost]-[BndPymntSubform].[Form]![TotalBndPayment]=Null,[Bond Cost],[Bond Cost]-[BndPymntSubform].[Form]![TotalBndPayment]) This expression will not give me the results if the [Bond Cost]-[BndPymntSubform].[Form]![TotalBndPayment]=Null it completes the rest of the operation. Can...
  4. N

    Calculating two fields from a form and a subform

    I have created a form with a subform and I want to subtract the total of the subform from the total of the form to get a balance; i.e. I have a total of expenses on the form and the subform is a record of payments against the expenses and I want to show a balance. I have been all over this one...
Back
Top Bottom