Using an input box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top