Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    New York
    Posts
    47

    Unanswered: requery subforms

    I am working with an Access 2003 db. The a major form is a subform that has a continuous subrorm in it. The main form is for a meeting, the first form chooses from a list of goals for that participants and the continuous form allows them to choose one or more objectives for that goal that were worked on.

    I need the second form to requery for the current goals for that client. It is done with a criteria in the lookup query that filters for the name of the client in the first form. This usually works.

    The third form then needs to requery for the objectives that go with that particular goal. It is set up the same way with a criteria that looks for that particular goal to filter for. This one is working very sporatically.

    My user base has a very low skill level so this is freaking them out. Help would be greatly appreciated.

    Terri
    Terri Gavin

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    How do you refer to the subform from the form and from one subform to another one?
    This may help: Forms: Refer to Form and Subform properties and controls

    Have a nice day!

  3. #3
    Join Date
    Dec 2003
    Location
    New York
    Posts
    47
    Thanks! that's a great resource but I think I have that right.

    Second form (referring to main) - [Forms]![frmProgress]![intChildID]

    Third form (referring to second) - [Forms]![frmProgress]![sfrmProgressGoal].[Form]![intProgressGoal]

    Terri
    Terri Gavin

Posting Permissions

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