+ Reply to Thread
Results 1 to 3 of 3

Verify data has been entered before adding new record

  1. #1
    Forum Contributor
    Join Date
    07-24-2008
    Location
    San Antonio, Texas
    Posts
    118

    Verify data has been entered before adding new record

    I have a form that has a command button called AllLoad that verifies the current record has certain fields filled in before adding a new record. The code works on the 1st part and returns a message box when the Number field has been left blank, but then does not return the message box when the Date field is blank and the Status field is empty, expired, or Not eligible.

    Please Login or Register  to view this content.
    Last edited by randolphoralph; 04-02-2015 at 01:51 PM.

  2. #2
    Forum Contributor
    Join Date
    07-24-2008
    Location
    San Antonio, Texas
    Posts
    118

    Re: Verify data has been entered before adding new record

    I believe the issue I am encountering is coming from the Me.Status <> 0.

    So what I am looking to accomplish on the 1st ElseIf is to return the message box if the Date field is empty and Status field is empty, but not equal to expired, or not eligible.

  3. #3
    Forum Contributor
    Join Date
    07-24-2008
    Location
    San Antonio, Texas
    Posts
    118

    Re: Verify data has been entered before adding new record

    Admin please delete this entire post as I should have posted on the Access forum versus Excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Verify that record dosen't exist on user form text box entry
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-16-2014, 05:23 PM
  2. [SOLVED] problem with adding record replacing first record
    By fredderf81 in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-17-2014, 12:28 PM
  3. [SOLVED] Verify if record has been posted to database before posting
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-13-2012, 01:07 PM
  4. Replies: 2
    Last Post: 01-30-2012, 06:53 AM
  5. Adding values to a cell based on entered data
    By Tin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2006, 08:55 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1