I need to move items into a table based on selections in a listbox. (Database Attached)
Attached is the database I am working with. The form is titled frm_Act1TO.
This form is used to log weekly activities done by the user in order to submit a weekly report to our client.
The user puts a date at the top of the form, chooses a task order, then chooses a subtask order, and then adds actvities to their report. New activities are added on the right hand side of the form.
I want the user to also be able to choose items from older reports and add them to their new report. This way, if there are no changes, the user doesn't have to type everything again.
On the left there are fields for two dates and a list box. When the user enters his or her information in the top of the form, he or she can then go to the date range boxes, enter dates, and pull up a list of items that have been logged in previous reports.
What I want to have happen now:
The user pulls up the list in the subform.
The user selects however many items they want added to the new report with the date they are currently useing.
The user clicks the Add Items to Current Report button and it takes the ActID numbers that are selected in the subform, adds them and the STOID and TOID from the Activities table and puts them into the StaffActivities table with the date selected at the top of the frm_Act1TO form.
Basically, I want the user to be able to add old items into their new report with the new date.
I am not sure how to do this because of the different elements involved (form, subform and table). I am probably just psyching myself out.
If testing the form, I recommend using Task Order BC and then choosing Sub Task Order 00-23rd Floor Receptionist. There are plenty of records there.
Thank you in advance!!!!