Results 1 to 2 of 2

Thread: comboboxes...

  1. #1
    Join Date
    Oct 2003
    Location
    Italy
    Posts
    1

    Lightbulb Unanswered: comboboxes...

    Hi,
    I have a problem :
    A database with few tables.
    I need to build a query from all tables.
    Then build a form with 3 comboboxes : 2 of them retriving the same "data" fields from one table.
    Another combobox retrive a list with "categories" from another table.

    Problem :
    I need to select between 2 dates, a category and then build a report with all products from that "category" who was introduced between "date 1" and "date 2".

    Help me... with some samples... I'm novice to VBA.

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    You do need a query, but no vba is required for this one.

    Select ProductID, ProductDescription from Products where DateIntroduced is between [forms]![YourFormName]![StartDate] and [forms]![YourFormName]![endDate];

    This form will have to be open for a report based on this query to work.

Posting Permissions

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