Search engine in a form

[eme126]

Hello everyone,

Here I am again all lost in the beyond side of Access. So, I would like to create a "search engine" , through a macros if possible, so that the users can find the one thing among the hundreds of specs available to them in this form/subforms assebly.

My form has two subforms inbuilt in it, hence it can be really time consuming to find the one piece of information they are looking for. And I was hoping that there was a way they could just type for example "rated voltage" in the search box and they would jump to the one textbox titled "rated voltage". Just like most of us do when reading a large document online, we just use "find" to get what we are looking for.

Thanks,

 

[KeithG]

You could use the afterupdate event on the search box to filter the sub forms

 

[eme126]

Ok, this might be a dumb question but, which search box??

 

[KeithG]

And I was hoping that there was a way they could just type for example "rated voltage" in the search box

This one