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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar