Simple Dynamic Client Search

[Lorne]

Hi all,



I am a business analyst who has been asked to build a database for a relatively small company. They do all of their data entry and reports on Excel, which has led to lots of double-triple entries and deleted formulas, etc. The company uses Access 2002 (yes, I know it is 2011, but they have not yet updated to the new Office, but will be within months)

Anyways, I have most of it built but am now in the process of making it more user friendly. While I am pretty comfortable with most Access functions, I am a novice when it comes to VBA code. I want to simplify the search process for finding a client. I have several tables, and the search field at the top of the form would be a client's information table that the user would search for, copy the Social Insurance # (Canadian version of Social Secuity #) and paste it in a field below.

I have been using a subform at the top of the form for the search field and provided instructions to either use [Ctrl][F] to find the record, or filter. I know there is a way to have it so that if the user starts typing the client's last name it will narrow down the records. I have been on several forums, tried a few of the suggestions, and I can't seem to get them to work.

If anyone has any advice it would be greatly appreciated!

[Rainlover]

In 2002 there is a simple wizard that adds a search Combo Bow to a Form, if that is what you need.

You have explained what you have done which is good but you havn't exxplained what method you want to employ that would suit your situation.

Or did I miss something.

[orange]

Lorne,

Here is a sample mdb. I t shows how, when searching for a lastname, each character entered in a textbox, causes the On Change event to fire. This in turn causes the data for the listbox to be re-queried (based on the characters entered so far). Tis basically reduces the Lastnames in the listbox.

It's in 2000 format so you should be able to read it.

Check the form design and the code behind the textbox and listbox.

Good luck.

[Lorne]

Rainlover & Orange, thank you so much for your quick responses!

Orange, your attachment was very helpful. I finally have a simple way to search through records on a form. My employer will be pleased.

[orange]

You are welcome, glad to help.