Assistance required for Tables

[Bill4tektips]

I have a database for Audit purposes and in it I have two tables, tblRequestAudit and tblPlanAudit. Essentially these two tables are the same but the tblRequestAudit is not numbered. Is there any way that when a checkbox is checked I can transfer the data into tblPlanAudit and delete it from the tblRequestAudit

 

[M8KWR]

you could create an ammend query to move the data you require into the tblPlanAudit, and then a delete query or the code below to delete the record you need deleting...

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

as long as you are able to write in the query to look at an id number on the form the user is using then this is possible.

You may also want to consider turning of the warnings etc, when a message box appears sayin are you sure you want to delete, or you have ammended 1 record, etc etc.

To turn these off use the code

DoCmd.SetWarnings False

I hope this helps