Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    240

    Unanswered: Help with query criteria

    Hi

    I seem to be having trouble trying to get a query to run a criteria. The criteria I added looks up a control that is a subform of two other forms, and I can't get this working.

    This is the criteria I'm using:

    [Forms]![frmWork_Placement]![frmWP_Details]![frmVetting].[Form].[cmboRiskRating]
    For a bit more info the forms are set out as follows...

    The frmWork_Placement form contains a tab control.
    The frmWP_Details form is on one of the pages of the tab control.
    And frmVetting is a sub form of frmWP_Details.

    Am I meant to be including references to the tab control?
    I'm only asking this because I have the same criteria above on a macro which runs OK.

    Thanks

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Looks like the form reference is wrong. Here's a good reference:

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

Posting Permissions

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