Results 1 to 3 of 3
  1. #1
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398

    Link between subform and mainform

    I have a multi-tabbed form. On tab 2 of the form, I have a combobox and a subform. I need the link for the subform to be with the combobox. How do I do that? When I try to create the link, the masterfields list contains the fields associated with the data source for this form. The combobox is not listed within these data fields.

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    The main form and the sub-form on Tab2 should *not* be linked.

    The sub-form on Tab2 should have the record source changed so that the criteria for the linking field references the bound field of the combo box.

  3. #3
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398
    Thanks. That's what I couldn't figure out.

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

Similar Threads

  1. Link SubForm to UnBound MainForm
    By JonMulder in forum Forms
    Replies: 0
    Last Post: 04-09-2011, 08:43 AM
  2. MainForm/SubForm question
    By 10 Gauge in forum Forms
    Replies: 5
    Last Post: 03-04-2011, 07:46 AM
  3. Filter a subform based on mainform
    By Cheshire101 in forum Queries
    Replies: 3
    Last Post: 01-06-2011, 12:56 PM
  4. Replies: 0
    Last Post: 03-14-2009, 12:33 AM
  5. copying data from subform to mainform
    By wasim_sono in forum Forms
    Replies: 0
    Last Post: 03-10-2006, 04:35 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