Recent content by abcibula

I believe the last time I got this to work, I used an EVENT on the field with the check box, but I can't remember exactly how I did it and nothing I have tried seems to work. I believe it was an "On Click" Event so that I didn't have to move off the record for it to update.

I have two subforms, Payments Due and Payments Received that are both linked to a Payments table. When a checkbox is clicked, the data moves from the Payments Due Form to the Payments Received Form. The forms are both based on Queries, one Query specifying the box is checked, and one...

I tried that and it gives me an error.

I have a report listed in a subform (in a tab) and I would like the report total value listed again on the main form. Is there a way to accomplish this?

I want to know what the total balance in the account is each month I want the balances to carry from the first month so if the first month +500 -250, the total for that month would be 250, then the next month, that 250 would be added to whatever deposits or withdrawals for that month's...

I figured out the union query, now the only problem I have is the running total. The report gives a final total and if I sort it by month, it gives the total each month, but not the running total each month.

I have 2 tables, one with outgoing payments, one with incoming payments. I need a report with a running total by month that adds all the payments in and subtracts all the payments out. I need the running total for each month, not just for the final total. Any suggestions?

I am trying to find a way to compile a report from two different queries that takes all the payments in and subtracts all the payments out. I need to keep track of the payments into and out of an escrow account and have the total balanced displayed on the main customer form. Any ideas of how...

I guess I am unsure how to get the text box on the pop-up form bound to the account number field. Once you enter the account number, those notes show up, but when you enter a new note, the account number is not automatically there.

That worked perfectly...thank you. Is there any way to get the Account Number field to auto-populate when you enter a note in the pop-up form?

I have a form with a field for "Account Number" and would like to have a form pop up when you click on the number in the field. I figured out how to use a macro to open the pop-up form when you double click the field, but all of the records pop up. I would like for only the records that are...