Using an input box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

suek - 23 Jul 2007 06:20 GMT

Hello,

I have a lookup table with 3000 records, so it's not really suitable for a
combo box.
What I want to do is have an input box up the top of the form where the user
enters a search, and a go button to perform the search. Given the data, it
is likely there will be more than one record from the look up table returned,
so I need these records displayed in such a way that the user can select the
correct record. From there the record needs to be stored as a new record, so
I would like to keep the data associated from the lookup table attached to it.
How do I do this?
Thanks

Reply to this Message

Allen Browne - 23 Jul 2007 06:26 GMT

How about a text box where you enter the data to find, and then you filter
the form so that it contains only those records that have a match?

This one does not require you to write any code:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

You select the field to look in (combo), and enter the value to find (text
box), and it filters the form each time you type a letter.

BTW, if you are using Access 2007, there is a box in the horizontal
scrollbar that does this kind of filtering for you.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello,
>
[quoted text clipped - 14 lines]
> How do I do this?
> Thanks

Reply to this Message