"Search" Form Help

[Os]

I have a simple question. How can I create a form in
Access97 to enable the user to search the dB by record,
then change/edit any record that already saved in tbl?
I created a form that shows all records in dB with all
fields. But it's difficult to scroll through thousands of
records to locate the desired one then edit it. I want
the user to type in (i.e. invoice #) and bring all fields
for that record. Any help is greatly appreciated.
Thanks.

 

[Hugh Horton]

This is dinitely inelegant and quick and dirty but if you
present the form in datasheet view all the menu bar
filtering and sorting options will be available to the
user.

 

[Jeff Conrad]

MVP Albert Kallal has a very good article about building a search form on his site. He even has some
screen shots which help you visualize the process. Hopefully, it will help you create a good search
form. You can find the article here:

http://www.attcanada.net/~kallal.msn/Search/index.html

 

[Os]

Thanks you Jeff. I will give it a try.

-----Original Message-----
MVP Albert Kallal has a very good article about building

a search form on his site. He even has some

screen shots which help you visualize the process.

Hopefully, it will help you create a good search

 

[Os]

I checked the website, but it's only screenshots that are
posted. There's no code or explanation on how to create a
search form in Access97. Any help from anyone is highly
appreciated.
Thanks.