Another search form

[Chris Wagner]

What I envision is a small box or form with 2 windows in it to accept
data.

Below is a table designed from a query in a worksheet format. This
worksheet is indexed on 2 fields.

In the form above when a person starts typing in a product code the
worksheet below will jump to that area of the table.
for example have 1000000 records product codes are a 5 digit
number lets say 85236 When someone types in the '8' above it would
jump to the first record that the product code starting with an '8'
then putting in a '5' the list below would jump to the first record
that starts with '85'.... and down the line.

Of course the would work for the second window.
this would quickly find the information if it does exist.

Any ideas on where I might look to do something like this. What are the
terms used (question form, Question Box, Search box??)

Even if I was able to enter the data in both boxes... press enter and
it would jump to that set of records in the table.
I haven't seen anything in the examples that might work but could
someone point me in the right direction

Thanks
Chris Wagner

 

[Chris Wagner]

Was able to get something else worked out with this problem

Chris