New to the forum but relatively competent in both Access and VBA. I suspect this may ultimately become a VBA question but thought I would start in the Forms section and go from there.
I am going to post a brief overview of what I have been tasked with in hopes of someone pointing me in the right direction if more information is needed I will certainly post more.
A company has a built a report that contains customer information such as First and Last Name Address things like that. These items are stored in the Cust.Info Table
This report is used for various things. The company has asked for me to place an Edit button on the report to allow people to submit edit requests. When they click the edit button it should launch a form pre-filled with that records information (the record they were viewing), allow the user to make their suggested changes and submit the information to be stored in a separate table Edit_Requests for viewing on a different report.
This posed some unique issues I've never addressed before and am hoping this forum can help me out.
First issue. I need to pass the unique "customer key" and record information from the report to populate the edit request form upon a button click.
Second when I edit that information and save, I need it to save to a different table than the table it was pulled from.
View record on report > Edit record in pre-filled form> save record to new/different table
Any direction you can provide will be much appreciated.
Thank you.