3 Queries - One Command

[eriel3]

I know this is a dumb question, but hey still need the answer.

I have several update queries that I want to run at one time on a form. Instead of putting 3 different buttons on my form to run this query, how can i tell it to run from the click of one button. Also, I need it to update immediate on the form so that the new information will show up. Right now, when I hit update, I have to go out of the form and the go back in to see the updated information.


Help!

 

[SiJP]

No dumb questions.. not asking questions is dumb.

In your button's on click event chuck in the following code..

Private Sub cmdButton_Click()
 DoCmd.OpenQuery "qryname1"
 DoCmd.OpenQuery "qryname2"
 DoCmd.OpenQuery "qryname3"
 Form.Recalc
End Sub

et voila?

------------------------
Hit any User to continue

 

[eriel3]

Thanks for the help.