Thanks for you help
Thanks for you help
And if they click NO, would you want to perhaps undo their action?
Someday I'll understand everything...
Even then...I'll still pretend I'm a beginner.
Private Sub Status_BeforeUpdate(Cancel As Integer)
End Sub
this is the event procedure
Originally Posted by wedd
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
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
I used a macro for the information message box but there isn't an option for a yes/no option...hence why i'm interested in writing a vba script...I add this code to a list box/combo box...the field with the drop down list is called status and the the database is called The Deal Log
I've added the code to the event procedure...when I click on the option I want nothing happens...the code is right..just not sure why it's not creating the prompt... :-S
Again, please post the VBA code.Originally Posted by wedd
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
Unfortunately, there is no way to do a vbYesNo messagebox within a macro.Originally Posted by wedd
Someday I'll understand everything...
Even then...I'll still pretend I'm a beginner.
So, I realised and it seems as if it's impossible to add vba code yes/no to an existing combo box...thanks for your help I'll just create it as an alert messsage box through a macro...thanks for your assistance. :-)
Last edited by wedd; 09-01-2010 at 05:59 AM.
thanks for your assistance
You can everything to an existing combo box that you can add to a new one.Originally Posted by wedd
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
Can you please describe what you want to happen in the event they click yes, and also what will happen if they click no.
Someday I'll understand everything...
Even then...I'll still pretend I'm a beginner.