Results 1 to 5 of 5
  1. #1
    twgonder is offline Expert
    Windows 10 Access 2021
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650

    How to suppress a warning messge in subforms that don't yet have a record?

    I've got a sub form that uses a command button to create a new record.
    When the form doesn't have an existing record, this message is displayed before the


    code for the "new" button begins to run (probably has to do with the subform going active), so I'm not sure what exactly is triggering it, or how to supress it.
    Click image for larger version. 

Name:	230429Msg1.jpg 
Views:	16 
Size:	18.3 KB 
ID:	50171



    The help for the error isn't much help, as MS has stopped supporting helps from their own link.
    Access error | Microsoft Learn (I wish I knew how to reliably cut and paste from Edge the entire link)

    There isn't a RTE number, it's just some kind of warning, but I don't need it as the user has pressed the "New" button knowing quite well a current record is needed and that is what they are trying to do.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    What other code do you have in the (sub) form's module?
    EDIT: see if this post helps:
    https://www.access-programmers.co.uk...-error.314001/
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    twgonder is offline Expert
    Windows 10 Access 2021
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650
    @Gicu, post# 2
    Good find search master!
    The very last post in that thread had the answer (why did I read it all?)

    There is a lot of other code, but most of it ran either before or after the error message, not during.

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    PM
    Usually the last post is the jackpot... Sorry I couldn't test it, been traveling for a while and all I have is some Android devices.
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    twgonder is offline Expert
    Windows 10 Access 2021
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650
    @Gicu, post#4 Yep, kinda like the old adage of: "it was found in the last place they looked". Of course, what fool would keep looking after it's found? And of course, the item can't be in two places. I just needed a hint as to where the message was coming from, easy after that. I tend to read all the messages, because I often pick up bits of other useful along the way. Thanks!

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

Similar Threads

  1. Replies: 2
    Last Post: 04-15-2023, 04:43 PM
  2. how to suppress this warning?
    By gunitinug in forum Access
    Replies: 2
    Last Post: 09-16-2017, 06:57 AM
  3. Suppress warning save changes to layout of table
    By bbrazeau in forum Programming
    Replies: 7
    Last Post: 02-13-2012, 01:57 PM
  4. Suppress new record on continuous forms
    By ajetrumpet in forum Forms
    Replies: 0
    Last Post: 09-07-2010, 09:30 PM
  5. suppress subtotals when only 1 record
    By schristy in forum Reports
    Replies: 3
    Last Post: 02-15-2010, 10:00 AM

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