Adding a "yes\No" Prompt to existing Open Form Command button

[Kemidan2014]

I have a simple Command button that opens a form when clicked. there is No VBA for this, i used the native Command button wizard to create the button.

I would like to add an additional message that pops up when its clicked to which Yes will continue to open the form and No will not open the form.

I have never played with the embedded macros associated with these types of buttons. Is it possible to do this or will i need to change it to a VBA _Onclick Code set up to do this?

 

[DanteAmor]

I did not understand what kind of button you have.
But if in that button you have a code to open the form, something like this:

Private Sub CommandButton1_Click()
  UserForm1.Show
End Sub

Then try this

Private Sub CommandButton1_Click()
  Dim res As VbMsgBoxResult
  res = MsgBox("Do you want to continue?", vbYesNo + vbQuestion)
  If res = vbYes Then
    UserForm1.Show
  End If
End Sub

If it is not the above, then explain with images and examples how you created that button, if you have any code in that button to open the form.

If you have trouble explaining it, you can use images.

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------​

 

[Kemidan2014]

Clicking "..." Takes you to below.

 

[Joe4]

I did not understand what kind of button you have.
But if in that button you have a code to open the form, something like this:

Private Sub CommandButton1_Click()
  UserForm1.Show
End Sub

Then try this

Private Sub CommandButton1_Click()
  Dim res As VbMsgBoxResult
  res = MsgBox("Do you want to continue?", vbYesNo + vbQuestion)
  If res = vbYes Then
    UserForm1.Show
  End If
End Sub

If it is not the above, then explain with images and examples how you created that button, if you have any code in that button to open the form.

If you have trouble explaining it, you can use images.

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------​

Dante, looks like you may not have realized you were in the Access forum and provided an Excel solution.

 

[DanteAmor]

Dante, looks like you may not have realized you were in the Access forum and provided an Excel solution.

Tienes razon, no puse atencion. Creo que todavía estoy dormido


@Kemidan2014, Sorry for my post, it's my mistake, I put you an answer for VBA Excel.

 

[Micron]

This can be done either way - embedded macros or code. I don't use macros (in the Access sense of the word macro) so I can only answer in general terms.
One of your macro steps would have to be to call a function which raises a message box in such a way that it returns the choice to that function that the user made. Your macro would then need an If statement that deals with the user response and either opens the form or not. Much easier to do in vba IMO.

 

[welshgasman]

Use VBA, not macros.. Macros are quite limited and very hard to debug.

How to force ms access form controls to generate code rather than macros

Access 2021 generates macros for form controls instead of vba code. How can I force ms access to generate code instead?

stackoverflow.com

 

[Kemidan2014]

I had changed it to VBA string, I was just curious how possible it was to do using Access Macro as it doesn't seem intuitive to figure out and Google searches like to blend Access macro \ VBA macro together so search results are not fruitful.

 

[welshgasman]

Well have a play.
I just tried and it does not even work as the documentation says it should.

From the Help

Not even going to waste any more time on this.