Append and Delete Query Question

[Mojo1]

I have an append and delete query that I want to run off the onclick of one command button. Currently it is only appending data and not deleting.

I have this in the criteria for the append and delete query's

[Forms]![Form Name]![From Field]

Here is what I have for the code of the command button as well:

Private Sub cmdArchive1_Click()



DoCmd.OpenQuery "AddRecord"
DoCmd.OpenQuery "ArchiveRecord"


End Sub


Can any one offer any help??

 

[gator]

Can you tell if the delete query is running at all?

If you post the sql from the delete query, this might help us help you.

-gator

 

[Dugantrain]

Is your delete query in your code? Neither "AddRecord" nor "Archive Record" sound like delete queries.