Delete records automatically frm table

[YamiMarik777]

How do you have Access delete records automatically from a temp table?

 

[Lister]

Write a Delete query and run it from a button even or from inside VBA code.

So

Dim strSQL, strCriteria As String
strCriteria = "[This is the Criteria or variable]"
strSQL = "Delete [Field Names] From [Table] Where [Field Names] = " & strCriteria
DoCmd.RunSQL(strSQL)

Write your Delete SQL in a Delete or Select query then move the SQL to the code.

Hope this helps