Results 1 to 20 of 32

Thread: Pop up hint messagebox

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #21
    Quote Originally Posted by wedd
    I've managed to create an information message box...but I want to achieve that when the user clicks on the drop down list a yes/no button has to be click to confirm their action
    Private Sub cboSheets_AfterUpdate()
        If Me.cboSheets = "Term Sheet" Then
            If MsgBox("Please confirm (Y/N) that the an active mandate has been agreed and therefore an engagment letter _
            has been agreed and signed with the client", vbYesNo, "Confirm") = vbYes Then
            Me.chkAgreed = True
        Else
            Me.chkAgreed = False
        End If
        Else
            Me.chkAgreed = False
        End If
        If MsgBox(prompt, vbYesNo, title) = vbYes Then
            MsgBox ("You clicked Yes")
        Else
            MsgBox ("You clicked no")
        End If
    End Sub

    Try this:

    Private Sub cboSheets_AfterUpdate()
        If Me.cboSheets = "Term Sheet" Then
            If MsgBox("Please confirm (Y/N) that the an active mandate has been  agreed and therefore an engagment letter _
            has been agreed and signed with  the client", vbYesNo, "Confirm") = vbYes Then
            Me.chkAgreed = True
            MsgBox ("You clicked Yes")
        Else
            Me.chkAgreed = False
            MsgBox ("You clicked no")
        End If
        Else
            Me.chkAgreed = False
        End If
    End Sub
    Last edited by Aussiebear; 02-01-2025 at 09:38 AM.
    Boyd Trimmell aka HiTechCoach
    Microsoft Access MVP -2010-2015

    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •