Delete Query on a form

[NaveenNandigam]

Hi, I have a form to which I update the information and hit a command button. Now this data has to be transfered to another form and get deleted from the original form. To acheive this I used Append and Delete Query(Both working). I have no problems assigning Append Query to a command, but I couldnt assign a delete query to a command button. I cannot see Delete query while trying to assign using a command button wizard. I even tried with an Build event while designing but its of no use. Can anyone help me with this issue????

Thanks in Advance
Naveen

 

[ghudson]

Use SQL for an action query...

DoCmd.RunSQL ("DELETE Table1.*FROM Table1;")

That SQL will delete all records in the table named "Table1".