Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy current record to last with popup in continuous subform

Status
Not open for further replies.

larrydavid

Programmer
Jul 22, 2010
174
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top