Results 1 to 3 of 3
  1. #1
    JackT is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    7

    Subform qry

    I have a form that searches for a reference number in a qry.
    Me.RecordSource = "SELECT * FROM qryCheckFiles WHERE " & Me.cmbRef & " = [APU REFERENCE NUMBER]"



    I want to populate a sub for to only display rows that match this qry and I am not sure how to do that.

    Jack

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by JackT View Post
    WHERE " & Me.cmbRef & " = [APU REFERENCE NUMBER]"
    interesting, i've never seen that section reversed. nifty!

    Quote Originally Posted by JackT View Post
    I want to populate a sub for to only display rows that match this qry and I am not sure how to do that.

    Jack
    need more info. a sub based on what? a child of a parent? that info is too vague to figure out jack.

  3. #3
    JackT is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    7
    its is a child of a form and the form is bound to the query

    jack
    Last edited by JackT; 09-01-2010 at 03:35 PM.

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

Similar Threads

  1. Pass Subform filter to subform in report
    By camftm in forum Programming
    Replies: 16
    Last Post: 07-19-2011, 07:12 AM
  2. Data from one subform to anther subform
    By scotribs in forum Forms
    Replies: 3
    Last Post: 03-09-2010, 09:53 AM
  3. Replies: 1
    Last Post: 03-06-2010, 06:30 PM
  4. Replies: 1
    Last Post: 12-10-2005, 04:52 PM
  5. Subform in a Subform and relationships
    By St3ph3n in forum Database Design
    Replies: 3
    Last Post: 12-06-2005, 06:34 PM

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