H Hunter J. Registered User. Local time Yesterday, 18:44 Joined Feb 1, 2004 Messages 24 Jul 14, 2004 #1 Is it possible to run multiple querys from one command button and if so how? Thanks for any help. Hunter J.
Is it possible to run multiple querys from one command button and if so how? Thanks for any help. Hunter J.
P Preacha Registered User. Local time Today, 09:44 Joined Jul 3, 2004 Messages 34 Jul 14, 2004 #2 In the command button click event, put . . . . Code: Dim stDocName,stDocName2, etc . . .. As String stDocName1 = "query1" DoCmd.OpenQuery stDocName1, acNormal, acEdit stDocName2 = "query2" DoCmd.OpenQuery stDocName2, acNormal, acEdit etc, etc. . . ..
In the command button click event, put . . . . Code: Dim stDocName,stDocName2, etc . . .. As String stDocName1 = "query1" DoCmd.OpenQuery stDocName1, acNormal, acEdit stDocName2 = "query2" DoCmd.OpenQuery stDocName2, acNormal, acEdit etc, etc. . . ..
H Hunter J. Registered User. Local time Yesterday, 18:44 Joined Feb 1, 2004 Messages 24 Jul 14, 2004 #3 Thank you. I will give that a try. Hunter J.