Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form for Queries (Access 2000)

    I've tried to implement the post 240382.

    Somewhere I'm missing a beat. The Query is not populated with the criteria.

    Thanks for the help
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form for Queries (Access 2000)

    Mario,

    There are two problems with your query:
    1. <LI>The value of the SupplNameSelected combo box is the value of the bound column, i.e. SupplierID, but you've put it under SupplierName. You should add SupplierID to the query and use that.
      <LI>The text box on the form is named PeriodSelected, but the query refers to Period.
    I have attached the modified database.
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form for Queries (Access 2000)

    Thanks Hansv

Posting Permissions

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