Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    39

    Unanswered: Have message box pop up when a field is not null

    I have a database which is used for assigning property that needs inspected, I have a master table called 'reval 2012' which stores all properties that needs inspected and three other tables for each property inspector. When assingning parcels that need inspected to a property inspector, the "Field_Person" field in reval 2012 gets updated with that inspector initals for the piece of property which tells me this property was assigned to this inspector. What I'm trying to do is have a message box pop up when assinging a property that has already been assigned to an inspector using 'not isnull' for the field_person field meaning if the field is not blank then don't assign this parcel again and let the user know this property has already been assigned.

    Clear as mud?

    thanks.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    You can try
    Code:
    If Not IsNull([Field_Person]) Then ...
    or you can try
    Code:
    If Nz([Field_Person]," ") > " " Then ...
    I prefer the latter, but different strokes...

    Sam

Posting Permissions

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