Search - Find record

[Guest]

Hi There,

I have a form that lists products by serial numbers, the form could have
over 1000 products. I would like to add a simple search for the users where
all they do is to enter the product serial number in a text box and hit go,
the product serial number that was requested is now high lighted. This action
should happen on the form that is currently open, no need to open a new form
for the searched items, just go and find it.



Regards,

 

[Allen Browne]

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

Although the article explains how to use a combo, the code would be the same
if you wanted to use a text box.