Moving a Record to another table

[Forbes]

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.

[pbaldy]

Generally speaking, you wouldn't move stuff from table to table (like "archiving"). You'd change a status field (or whatever) and just filter on that. To move it, you'd use an append query and then a delete query. To update it, you'd use an update query or recordset.

[June7]

Should not have to copy/move records to accomplish what you want.

In addition to what Paul describes, review http://www.andypope.info/vba/listboxmover.htm

[Forbes]

Thanks for the advice! I am working on making this happen now, I will update you on the status when I have moved forward, this project is a little slower moving than my others

[Forbes]

This all worked great, quite a bit of re-engineering. IDK where I would be with-out you guys. Cheers!