Results 1 to 4 of 4
  1. 01-17-2012, 02:31 AM #1
    beat
    beat is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2011
    Posts
    9

    Arrow Using a dropdown list to change criteria


    I have an query containing sales orders of 100+ customers. I have to create a dropdown list to manipulate the field "criteria" so the user can limit to data analyse to a certain customer without typing the customers name themself everytime.

    Help. anybody?
    Reply With Quote Reply With Quote
  2. 01-17-2012, 09:57 AM #2
    orange's Avatar
    orange
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Why is this marked solved? Did you find a solution? If so, others may be interested.
    Reply With Quote Reply With Quote
  3. 01-17-2012, 08:39 PM #3
    beat
    beat is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2011
    Posts
    9
    it s acctually not solved. yet.
    Reply With Quote Reply With Quote
  4. 01-18-2012, 12:26 AM #4
    beat
    beat is offline Novice
    Windows Vista Access 2003
    Join Date
    Dec 2011
    Posts
    9
    solved. if anybody is interessted find the solution here:
    http://www.databasedev.co.uk/query_filter.html
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to create table that change according dropdown list?
    By Stuxnet in forum Access
    Replies: 2
    Last Post: 10-11-2011, 07:24 PM
  2. Dropdown list
    By stratack in forum Access
    Replies: 1
    Last Post: 07-25-2011, 06:58 AM
  3. Change database where data is stored with a dropdown box
    By le_carrington in forum Programming
    Replies: 5
    Last Post: 11-25-2010, 11:45 PM
  4. Set up a dropdown List
    By asherbear in forum Access
    Replies: 2
    Last Post: 06-24-2010, 06:45 AM
  5. Dropdown list in a query
    By asherbear in forum Queries
    Replies: 6
    Last Post: 05-31-2010, 06:38 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums