Results 1 to 2 of 2

Thread: Form MsgBox

  1. #1
    Join Date
    Feb 2010

    Unanswered: Form MsgBox

    Hi all,

    I am trying to create a msgbox popup for a form

    The form has multiple fields. One field is either "Y" or "N" for each record and I want a msgbox to pop up everytime I go to a record and the field is "Y".

    Any help would be appreciated. Thanks!

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Private Sub Form_Current()
     If Me.YourFieldName = "Y" Then MsgBox "The field's value is 'Y'"
    End Sub
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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