Re: [MS_AccessPros] making a list box based on a multi-value field display user friendly values

Hi John,
I was searching this forum for a solution and came across the thread,
"Populating
an unbound textbox with multi item field ", which you contibuted on. It
seemed like a similar problem but I can't figure out how to adapt it to my
need. I know multi-value fields are bad, but the original project is
totally dependent on them. I have looked online for an explanation of a
substitute that creates the same functionality in access without using them
but I haven't found it. I am posting the file Referral Database.zip Thank
for your interest.
Chaz

On Wed, Jul 17, 2013 at 12:08 PM, John Viescas <JohnV@msn.com> wrote:

> **
>
>
> 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
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/