Hello,
I'm trying to move a record from one table (prospective client) to another (client). I understand the mechanics of using an append query (to move), then a delete query (to remove from prospective client table), then an update query to change the client type in the 'client' table. What I'm unclear on is how to execute this from the form itself - how do I specify to Access that I want to perform the queries on the active record (in the prospective client form)?
Thanks so much for your assist...and if I overlooked an obvious answer in my search, my apologies!