Run Append and Update Queries

[Govinda]

Hi everyone,
I'm a beginner in access vba. i have some records in a table. i'd like to know if i can run an append query and a update query with a click of single button. i tried the following code, but couldn't append and update even a single record.
DoCmd.OpenQuery "X"
DoEvents
DoCmd.OpenQuery "Y"

a quick reply would help me a lot. thanks in advance gyus.



Regards,
Govind

[June7]

I split your post to its own thread. Should always post your question to a new thread.

That code should work.

Show the SQL statements of the queries.