Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: Subform Query Source

    Hi, some help here people,

    I want to create a form to display information on orders. Each order can have multiple components, and I am thinking of just using a continuous/datasheet subform to display this. I intend using a combo selector box as the control for the subform, and using a SELECT query to retrieve the records relating to order selected...

    Now the question, I have a query to select the relevant info., but have only just finished it, so have only used it via the design window...

    Will I have to change the SQL query statement to search for specific records - by editing the querydef - or is there an easier way of specifying the relevant order no. in the query?

  2. #2
    Join Date
    Jun 2004
    Posts
    6
    Take a look at the Customer Orders form in the Northwind database.
    Suspect that's pretty close to what you're describing.

    HTH-Bob

Posting Permissions

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