Results 1 to 3 of 3

Thread: null values

  1. #1
    Join Date
    Feb 2004
    Posts
    106

    Unanswered: null values

    I'm trying to validate whether a user selects an item in the combo box or if he leaves it empty. However, when I try to validate:

    If Me.cbo_bc = null then
    stDocName = "rpt_Schedule1"
    DoCmd.OpenReport stDocName, acPreview
    End If


    it skips over the statement as if the combo box is not empty. what am I doing wrong?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    If IsNull(Me.cbo_bc) then
    stDocName = "rpt_Schedule1"
    DoCmd.OpenReport stDocName, acPreview
    End If

  3. #3
    Join Date
    Feb 2004
    Posts
    106
    GREAT, that works... thanks.

Posting Permissions

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