Comments when clicking a button

[Juan4412]

There is a form that I create, I have a buton that run a query, how would I add a statement that show, when button clicked that asks, are you sure you want to run this query?! And they have the option of yes/no.


Can someone provide some reading material for me to learn further on how to do this trick?

[ketbdnetbp]

If you are using VBA (Button: OnClick=[EventProcedure]) to Open the query, you could try this -

If MsgBox("Click YES if you are sure you want to run this query. Otherwise, Click NO!", vbYesNo + vbQuestion, "Run Query ?") = vbYes Then
DoCmd.OpenQuery "YourQueryName"
Else
Exit Sub
End If

Hope this helps,

Jim

[Juan4412]

Sweet, that is excremely simple! Thank you for time/assistance. Is it always in this format....

If MsgBox("Click YES if you are sure you want to run this query. Otherwise, Click NO!", vbYesNo + vbQuestion, "Run Query ?") = vbYes Then

Like could I add in a = vbNo then?

Like how would I say that if = vbNo Then
go back to form that you were on.

Does that make sense?

[ketbdnetbp]

There are a number of ways you can change/customize the MsgBox to meet the needs of your application/users.

As a starting point, go to the VB editor, Help (F1), search for MsgBox Function. It should explain all of the options that are available.

Hope that gets you started.

All the best,

Jim

[Juan4412]

That showed me what I needed, thank!