Results 1 to 5 of 5
  1. #1
    dbright4 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    2

    Exclamation Use of dropdowns to pull specific Query fields


    I need the ability to create a dropdown list based on the fields in a query (i.e. clientID, Client name, etc.) and then the value associated with that field show up next to the chosen field label...any ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    this makes no sense. The form shows the records.
    The combo CAN show the field names, but youd have to enter them manually.
    Normally, the query is automatic in showing values, not fieldnames.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    dbright,

    Instead of telling us HOW to do something, why not tell us in plain English WHAT you are trying to accomplish?
    A sample with real data showing before, and desired output often helps put the request into context.

    Good luck.

  4. #4
    dbright4 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    2
    My apologies...trying to convey what I am trying to do as best as possible. Essentially what am trying to do is the following:

    In a report, show a dropdown of the Fields from a query. When the user selects the field they wish to see, the corresponding value will show next to the dropdown. For exapmle, I have 20 fields in a query and the user selects "ClientID" from a dropdown. That query will run and there is a criteria question for them to type in a unique Identifier to limit the query result to 1 record and it would show the "ClientID" for the record. Below is visual of what I am trying to do...

    Click image for larger version. 

Name:	access.png 
Views:	6 
Size:	1.5 KB 
ID:	24192
    Does this help?

    Thank you for your responses and time. I really appreciate the help trying to figure this out.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    So what is the template of the query you intend to run? Or do you have a separate query for each field?

    Also, this sort of thing would usually be done in a form, not a report. Here's a link to dynamic reports by Martin Green.

    ...a criteria question for them to type in a unique Identifier to limit the query result to 1 record and it would show the "ClientID" for the record...
    If you have a field list, will you also have a list of valid values for some of those fields?

    It seems strange that a user would know the ClientID vs the ClientName. Usually you try to hide IDs from users and give them a "more common attribute" to work with.

    Good luck with your project.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-23-2016, 08:36 PM
  2. Dropdowns based on other dropdowns
    By Heathey94 in forum Forms
    Replies: 5
    Last Post: 02-12-2016, 04:55 AM
  3. Replies: 2
    Last Post: 10-30-2015, 12:19 PM
  4. Replies: 1
    Last Post: 08-01-2012, 12:50 AM
  5. Referencing Dropdowns to multiple fields
    By John Mundy in forum Forms
    Replies: 2
    Last Post: 11-14-2011, 05:15 AM

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