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!