Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: checking condition

    I have a form which takes in an input and I need to make sure it is not null

    If IsNull(WorkorderNo) Then
    MsgBox ("Enter WO")

    End If

    DoCmd.Close
    Presently if the workorderno is null, it displays the msg and then closes
    I need to alter this so that until workorderno is not null, it doesnot close

    thank you

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    Do while Not IsNull(WorkorderNo)

    MsgBox ("Enter WO")

    Loop

    DoCmd.Close
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

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