User friendly combo box

[Sandra Teng]

Hi,
I have created a combo box that if the user enters a number, the combo box
will pull out the form. However, I would like the box to promp the valid
selections when users click on the arrow. Can anyone please tell me how to do
so? Thank you!

 

[BruceM]

As a guess as to what you mean, you would rather have the user select a name
than a number. In that case, make a two-column query with the number in the
first column and the name in the second. Use the query as the combo box Row
Source. Set the combo box Column count to 2, the Bound Column to 1, and the
Column Widths to something like 0;1.5. Any code in the combo box After
Update event will probably work as before, but the user can select the name
rather than the number.

If you need more information, or if the guess is incorrect, please provide
more details.

 

[Sandra Teng]

Hi Bruce,
Thank you for your response, I am sorry that I didn't address the problem
clearly.
I would like to write a program so that everytime, in the form view, the
user can select an item from a pull-down menu, and the combo box will spit
out any forms that contains anything that matches the selection.
Can you help me with that? Thank you so much!

 

[BruceM]

Your terminology is colorful but imprecise. I don't understand what you
mean about Access spitting out forms. I suspect you mean records or reports
rather than forms. A review of some terminology may help:
http://allenbrowne.com/casu-01.html

Another thing that may help is if you describe your database's structure and
purpose, and in non-database terms describe the desired outcome after
selecting an item from the combo box..

 

[Sandra Teng]

Hi Bruce,
Thank you.
I have one table imported from an excel file that contains 128 rows. Each
row has an information about a person. In each row, there is an ID, the
person's contact information, and special notes. I have created a combo box
in a form that allows me to enter an ID #. However, I intend to make this
combo box feature a search bar. So that when I click on the textbox or combo
box, it'll have me enter any text, and then show me display any row in the
table that contains the text that I have entered.
I hope this helps to explain what I want Access to do.
Thank you agian,