move records to different table

[Guest]

I have a question about creating some sort of checkbox in a form that upon
being checked will move a record to a entirely different table that can be
referenced indepently at some other time. I would appreciate some helo on
this since i am a novice access user.

 

[John Vinson]

I have a question about creating some sort of checkbox in a form that upon
being checked will move a record to a entirely different table that can be
referenced indepently at some other time. I would appreciate some helo on
this since i am a novice access user.

This can be done... but it's probably neither necessary nor
appropriate to do so!

Instead, put a Yes/No field in your table named Archived. Base your
Form on a query selecting only those records for which this field is
False. Now if you check it on the form, it will disappear from view
when you move off that record or close the form. You'll need some
other process (a form showing only archived records by selecting
Archived=True in its query for example) to reactivate the record.

With an index on the field, this will be more efficient than the
somewhat complex process of appending the record to another table,
deleting it from this table, and then reversing the process.

John W. Vinson[MVP]