larrydavid
Programmer
Hello,
On my continuous subform I need to have a popup form (preferably acDialog) add two values to the current record, then subtract that amount from the current record. Then, add a new record with the adjusted amount.
So, they expected input/input would be:
Input:
Popup form: [tx_id],[amount] = $100.00 - $50.00 entered in popup form textbox.
Output
Subform: [all columns in subform],[amount] = $50.00
The problem I'm having is copying that record as the new record. I wasn't sure if this should have been posted to the Microsoft: Access Modules (VBA Coding) group also but I wanted to avoid cross-posting.
Any help would be greatly appreciated.
Thanks,
Larry
On my continuous subform I need to have a popup form (preferably acDialog) add two values to the current record, then subtract that amount from the current record. Then, add a new record with the adjusted amount.
So, they expected input/input would be:
Input:
Popup form: [tx_id],[amount] = $100.00 - $50.00 entered in popup form textbox.
Output
Subform: [all columns in subform],[amount] = $50.00
The problem I'm having is copying that record as the new record. I wasn't sure if this should have been posted to the Microsoft: Access Modules (VBA Coding) group also but I wanted to avoid cross-posting.
Any help would be greatly appreciated.
Thanks,
Larry