Hello fellow Access enthusiasts
I have a form with 3 List Boxes lets call them This Week, Next Week, and old.
On the form you can move a record from one list to the other using a command button. (Like from Next Week to This Week)
I'd Imagine it would have to be something along the lines of copy record to tbl and delete record from prev tbl.
Both tables have the exact same layouts and fields.
I guess I'm just looking for a starting point to educate myself on the best way to do this.