Auto Suggest

[Makem]

Hi, I would like a simple 4 field database that will display matching data records as you type each letter into a search box.



The list should be sorted on the search field & is only required to be viewed as once the list is down to a few matching records the required data would be read before another search started.

Is this posible in Access?

[NTC]

the standard combobox or listbox - which are controls/fields in a form.....will auto-complete as one types into the field. Thus is the table source for the combobox is:
Apple
Auto

When you type A - then Apple will appear....if you add U - then Auto will appear...

beyond that I don't understand your requirement for the "required data would be read before another search is started"

read by the user?

[Makem]

Sorry if first post is not clear, will try to explain.

Typing a
would list all starting with a in a list below search box. The list may contain too many a's to view so it may only show the first 10 for example.

if items were Ape,Apple, Auto.

It would look like

a (in search box)

Ape
Apple
Auto

adding a p (ap)

Ape
Apple

adding an e (ape)

Ape

If there were 10 items or less starting with Ape then all would be on view. I would not need to do anything with the data (don't require to use it on the computer) other than read it but then would need to do another 10-40 searches.

An example is shown here http://www.asfusion.com/examples/ite...e-cfform-flash but this is for use on a web page but I require it to be usable on a computer not connected to the internet.

[NTC]

as you self describe yourself as a novice; the answer is qualified...
a combobox is simple - it will auto jump to whatever text the user is typing in....but it shows everything - you can scroll up and down and see all entries...

one can build a query driven approach that appends the wildcard * after every string of text entered - so it shows only those entries that begin with the text that has been entered......but it is not a novice friendly solution that can be explained in this type forum if it must be elegantly presented via a form to a non-technical user.....to experiment with it in query format...just build a small table, and make a query using the wildcard...