Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Posts
    8

    Unanswered: Form breaks when it ismade a subform

    I made a form works great. it has a combo box that selects a record from a table. I have two listboxes that are populated/filtered by the record that is selected. When I place this form on a tab form/control the listboxes no longer see the bound column of the combo box. What am I doing wrong. The list boxes are fed by 2 different queries which use a criteria of [Forms]![RaceNights]![Combo13] for the RaceID. Is my problem due to me not identifying the value correctly because it is now a subform? Any help would be much appreciated.

    Thanks,
    Steve

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Correct method of referring to the subform here:

    http://www.mvps.org/access/forms/frm0031.htm
    Paul

  3. #3
    Join Date
    Nov 2005
    Posts
    8
    Thanks, I was afraid that was the case. I'll give it a shot tomorrow. It just does not make sense to me though that if it works as a form it should work as a subform. Oh well. I'm pushing the "I believe" button. I'll let you know how it turns out.

    Thanks,
    Steve

  4. #4
    Join Date
    Nov 2005
    Posts
    8
    Ok so I could not wait. Yep needed that reference to the parent form.

    Thanks
    Steve

    P.S The trick was finding all the places that I had referenced the sub in the queries and row source.

  5. #5
    Join Date
    Nov 2005
    Posts
    8
    Ok I see myself running into this again as forms get nested. Is there a way to dynamically keep the criteria updated. so as I nest these forms I don't have to go back and add the new parent to the criteria and so that when I run the form by itself it does not appear to be broken because it has an extra parent in the criteria.

    Thanks,
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •