Recent content by NVAlice

Okay, I think I loaded the database as a zip file. I hope this works. Thanks for your help NVAlice

I would be happy to post a copy of the database, could you tell me how? I don't know much about VB so I have tried to use the macros instead. This should be a simple macro I am just doing one small thing wrong. When the value in the field is "credit card" I want the macro to open another...

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"...

=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...

Thank you John 471. That seemed to work the best. NVAlice

Okay, I tried this and it didn't work. I only get the balance due if I put a value in the payment field. It actually worked just like the first formula I did. I tried to post a screen print of the problem but couldn't get it to copy over to this forum. This expression is made up from a form...

=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...

Thank you I will try this formula

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...