more than 1 queries on a button cmd

[GaryPanic]

Hello Access guru's
I have access 2000 - and have build the d/base pretty much as needed - however I want to be able to run 2 or three queries on one button

I have looked at the docmd option and not being the brightess bunny - cannot seem to wrap my head round this

the queries are append queries
quereie one updates table 1
querie two another table and querie three yet another

1 is accounts a hsitory table
2 is a renewal process into a diary table
3 is a bit of admin reporting table


any ideas

slightly out of my depth

regards

 

[Sergeant]

Private Sub Command1_Click()

DoCmd.OpenQuery "NameOfQuery1"
DoCmd.OpenQuery "NameOfQuery2"
DoCmd.OpenQuery "NameOfQuery3"

End Sub

 

[Smart]

In the on click of your button type

docmd.setwarnings = false
docmd.openquery "your1st query"
docmd.openquery "your2nd query"
docmd.openquery "your3rd query"
docmd.setwarnings = true

 

[GaryPanic]

Thanks - I finally got round this problem - but not the way you suggested - however I prefer your route - ( a lot tidier) I will back track and amend what I done - to what has been pointed out

many thanks to all the persons whom always seem to be ready to help -

Some times a little thank you can go a long way

regards
Gary not so paniced