Searching through a form table

[jwo1985]

Afternoon!

I've just created a table which contains the details of all of the clients for this company. I've moved on to create a form which takes just a small section of the table (client code, client name, web address) and the idea is that the eventual end user can use the form to search for a client and then click and open that client's particular details.

For example, I want to be able to do is find a client by typing the code into the client code row. So for example i type 'S' and I'm instantly scrolled down to all the client codes beginning with S, n then type (again for example) 'h' and I'm met with all the client codes commencing with 'Sh'.

Now when I first tried this I found I could edit the data, which i obviously didnt want so I've since locked out the text boxes so a user can't edit them but the user still can't search which is most unfortunate. It's probably just a simple setting that I'm not seeing, maybe a property that's set as 'no' when it should be 'yes' or vice-versa. I've seen this done on another database so I know it can be done, however it wasn't a database created with Access unfortunately.

Anyone able to offer any assistance?

 

[jwo1985]

...so that's a no then!

Thanks to all who viewed!

 

[Dennisk]

use the combo box wizard to find records where you can enter one of two letters.

 

[neileg]

To add to Dennisk's advice, the natural properties of a combo box is that it will 'zoom' to an entry as you type in the box. I'm prtty sure this will give you what you want.