Creating a search form

[chris.f]

Hi,

Sorry if this is a stupid question but I am a newby in access and I was wondering how I can create a form where there is a textbox and list of all the records underneath, as I type characters into the textbox, the table underneath auto-scrolls to the most relevant record?

Thanks in Advance,

Chris

Edit: Speling

 

[boblarson]

Just so you know Chris, it is possible to write the code to do it, but Access is not multi-threaded so it would slow your data entry time down immensely as you type because it will need to iterate through records on each keystroke and that can take some time. So, I think you'll find that it would make things worse, instead of better, for your users.

 

[rsmonkey]

Your best option is to either create a combobox with a limit to list function which does exactly as you ask or you could have a search function you type your criteria into a text box click search and a list of potential results will be shown, then you can simply select one of these and it will populate your form. All of these examples can be found in the samples section. Try using the search function it might narrow your search