I Have a table that stores transactions details that occur during a normal business period.
*The Columns on that table are as followed*
ID (PK)
Date
Client_ID (CK)
Volume
Amount
Statement_ID (default is blank)
at the end of the cycle, I would like to select which transactions get assigned to the opened billing statement. I set up a form that looks similar to an invoice. A client is selected from the combo box then a date range is used to filter and display the data within that date range on the popup form.
On the popup form, there is a listbox which has the same columns with "ID" hidden, the objective is to update a selected list item record with the current statement ID. If the row is selected Update Statement_ID to equal the current ID or if it is unselected then update statement_id to null. I included some photos for reference. Iv tried researching the matter but, haven't had any luck with putting a code together.
I am self-taught & continuously learning providing sample VBA is greatly appreciated as I can study it, modify, test it then post back the working code for someone else in the community to benefit.
I tried posting photos according to instruction, but it doesn't seem to work for g drive accounts.
https://drive.google.com/open?id=1w_hy38zKyvvZaa9Gadhn-SrY6TlXtEXW
*The Columns on that table are as followed*
ID (PK)
Date
Client_ID (CK)
Volume
Amount
Statement_ID (default is blank)
at the end of the cycle, I would like to select which transactions get assigned to the opened billing statement. I set up a form that looks similar to an invoice. A client is selected from the combo box then a date range is used to filter and display the data within that date range on the popup form.
On the popup form, there is a listbox which has the same columns with "ID" hidden, the objective is to update a selected list item record with the current statement ID. If the row is selected Update Statement_ID to equal the current ID or if it is unselected then update statement_id to null. I included some photos for reference. Iv tried researching the matter but, haven't had any luck with putting a code together.
I am self-taught & continuously learning providing sample VBA is greatly appreciated as I can study it, modify, test it then post back the working code for someone else in the community to benefit.
I tried posting photos according to instruction, but it doesn't seem to work for g drive accounts.
https://drive.google.com/open?id=1w_hy38zKyvvZaa9Gadhn-SrY6TlXtEXW