Results 1 to 5 of 5
  1. #1
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754

    ClsModule and a NotInList Event


    Hello All,
    I am having a problem with trying to get around an after update event that runs a clsMod. I believe the Mod is telling it to just put in null values into the fields if no match, but does not run the NotInList.
    What I am trying to do is when I enter a ZipCode that is not in the list, I want to be able to open a form per my CboZipCode_NotInList(), so I can put the ZipCode into ZipCodeTable and Put into the CSZTbl also. I of coarse didn't write the mod so I am not real sure how to alter it to let me run the notinlist, or if that is event the problem? I have attached the db which I took out most of the data due to size so I could upload it here.
    Form in Question is AddressFrm and the filed is CboZipCode.
    Thanks for assistance
    Dave
    CSZ Data - Copy.zip

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why is SCZAddFrm UNBOUND?

    Combobox LimitToList property must be Yes for NotInList event to trigger.

    I've never created a custom class but will try to figure out.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Thanks June7,
    That did the trick. As far as the unbound form, I didn't want a record set with it as it is just to add new data to a table. Cant add anything without doing something such as save.
    Thanks

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Bind form then either set form DataEntry property to Yes and then can only add new record or dynamically open form in add record mode. No need for INSERT sql.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    thanks, I will give that a try!
    Dave

Please reply to this thread with any new information or opinions.

Similar Threads

  1. NotInlist Event not working properly
    By thanosgr in forum Programming
    Replies: 2
    Last Post: 06-14-2012, 01:46 PM
  2. NotInList event
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 04-13-2011, 09:10 AM
  3. NotInList event issue
    By elinde in forum Forms
    Replies: 1
    Last Post: 04-01-2011, 08:43 PM
  4. Cancelling the NotInList event
    By Remster in forum Programming
    Replies: 12
    Last Post: 11-21-2010, 10:12 AM
  5. Troubleshoot NotInList Event Procedure
    By skyrise in forum Programming
    Replies: 4
    Last Post: 02-23-2009, 06:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums