Results 1 to 2 of 2
  1. #1
    Tore is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    1

    combox in subform does not synchronize with main form when filter is applied

    I have a main form in form-view with a subform in datasheet-view. The subform shows data related to the main form.
    The subform has two combobox columns and two textbox columns.
    When I select another record in the main form the data in the subform is updated correctly, everything is OK.

    If I apply filtering in the main form, the combobox columns in subform are not updated, they turn blank.
    This is an error. I apply filtering the following way: I right-click on a number field in the main form, select “Number filters -> Equals” and fill in a number to go to a specific record.

    Filtering in the main form seems to do something with the comboboxes in the subform.

    The form and the subform are linked with Link Master/Child fields.
    I have tried Combobox.requery on subform current event without success.
    What could be wrong here?

    Regards

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Filtering in the main form seems to do something with the comboboxes in the subform.
    I suggest you tell us about your application in plain English so we can understand your issue and approach in context. I also suggest your post a copy of your database in zip format. Please provide instructions to get the "condition" you are reporting including some sample values.

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

Similar Threads

  1. Synchronize a main form from it subform
    By WCStarks in forum Forms
    Replies: 10
    Last Post: 10-23-2018, 05:38 PM
  2. Replies: 39
    Last Post: 07-28-2018, 12:27 PM
  3. Replies: 8
    Last Post: 03-05-2016, 10:39 AM
  4. Replies: 5
    Last Post: 03-15-2013, 10:53 PM
  5. How to open a form with filter applied?
    By rkm360 in forum Access
    Replies: 1
    Last Post: 03-18-2009, 09:27 AM

Tags for this Thread

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