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?
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?
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.
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.
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...
Does this help?
Thank you for your responses and time. I really appreciate the help trying to figure this out.
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.
If you have a field list, will you also have a list of valid values for some of those fields?...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...
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.