I have a make table query that pulls records from Table1 to Table2 based on criteria given by the user. The user updates those selected records in a form.
I originally had a select query that prompted the user, but when I added code to the form to refresh it, the user was prompted for the criteria again.
What I need is one of two things:
1. A way to replace the records in Table1 with the records in Table2, or
2. Code to refresh the form so that it will not prompt the user for the criteria everytime.
Thanks!
I originally had a select query that prompted the user, but when I added code to the form to refresh it, the user was prompted for the criteria again.
What I need is one of two things:
1. A way to replace the records in Table1 with the records in Table2, or
2. Code to refresh the form so that it will not prompt the user for the criteria everytime.
Thanks!
