Chaz-
Are you saying you're doing a lookup on a multi-value field? <sigh>
Multi-value fields are the devil's invention. You can display the
individual items by dropping the .Value property listed under the
multi-value field in query design. If there is a lookup table for the
multi-value field, you can adjust the Row Source, Bound Column, Column
Count, and Column Widths to display related text instead of just the code
number. I would need to know more about the actual design of the underlying
table to help you further.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of chaz
Sent: Wednesday, July 17, 2013 5:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] making a list box based on a multi-value field
display user friendly values
I am trying to fix a project started by another person which has a form
which uses multi-value combo boxes to store key values. I have to create a
dynamic multi-field search form to look up community resources for mental
health. I have created a multi-field search form based on a query which
displays the lookups in a list box but the results are numbers (bound field)
and can only be queried by putting in a number which doesn't work well (put
in the number 2 and everything containing 2 returns), not to speak of being
non-user friendly. It is my understanding that the values I want to display
(they show up in the query) are hidden in Access' multi-value field
mechanism. Does anyone know how I can access them to be displayed in the
list box and searched by typing them into a text box? This project is a good
cause and will be used to help many people in my community and made
available to other agencies to use as well. Thanks in advance.
Chaz
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar