Results 1 to 2 of 2
  1. #1
    deepucec9 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2015
    Posts
    34

    list records in sub form based on combo box from main form

    Need to list the records in subform matching the combo box from main form.
    Creating a warehouse inventory, main form name is job_main and subform name is casid_sub (continuous)


    There are two combo box in main form (unbound) "caseid" and "job"
    After selecting these two field system should list all the matching records in sub form.

    TIA

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    without any code required, put in the subforom linkmaster property

    caseid, job

    and in the linkchild property put

    caseid, job

    if these are the names of your fields in the subform recordsource

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

Similar Threads

  1. Replies: 1
    Last Post: 04-14-2014, 01:38 PM
  2. Replies: 4
    Last Post: 07-11-2012, 10:31 AM
  3. Replies: 3
    Last Post: 12-01-2011, 06:51 AM
  4. Subform Combobox based on Main form combo box
    By accessmom in forum Forms
    Replies: 5
    Last Post: 02-21-2011, 07:02 AM
  5. Replies: 5
    Last Post: 01-02-2011, 10:09 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