Results 1 to 2 of 2
  1. #1
    Corinna is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2023
    Posts
    1

    A query dependent combo failed to update

    I've an insert mask with 2 combobox (CBA and CBB)
    User choose a record in CBA,
    this value udate a query.


    The query result is shown in CBB.

    After mask is opened all works fine but if I pass to the another record and I choose another record in CBA the CBB values don't change. The query instead yes.

    I try with Refresh after update of CBB but it doesn't works.
    Any suggestion?

    Thanks a lot

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    not at all clear what you mean but sounds like you might be talking about cascading combo's. If this is correct, you need to requery (not refresh) CBB from the CBA after update event or the CBB got focus event

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

Similar Threads

  1. Replies: 14
    Last Post: 07-11-2021, 09:53 PM
  2. Replies: 6
    Last Post: 04-15-2019, 09:03 PM
  3. Replies: 2
    Last Post: 03-23-2017, 01:16 PM
  4. Replies: 6
    Last Post: 02-01-2013, 10:02 AM
  5. Update Query Dependent on the month
    By hawkins in forum Queries
    Replies: 3
    Last Post: 07-12-2011, 08:54 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