Access Newbie

[jeh]

Hi Everyone,
This is my first post in the Access side.
I have only one table in my database. What I'm trying to do is have a form that will have a combobox? that I can type in a name, and I will it will return all of the names in that field that are similar to one i typed in the combobox. I know I will need a query to do this, but I'm having a hard time even getting that one right. Does anyone have a sample data bease that uses a form where they search for records using the "like" function. Or point me in the right direction?

Thanks for your time,

Jim

 

[Parra]

This is what I would do in the query.

In the critria of the field.
Type the following
[Enter Name]
So when you run the query, a pop up box will appear. Type the name you are looking for. I am sure you can also wild cards with it.

Does this help?

 

[Bariloche]

Jim,

You should have the "Northwind" database installed on your computer. Its a sample database that ships with Access. Look in your C:/Program Files/Microsoft Office/Office/Samples folder, it should be there if its installed. That database has a number of examples of queries, forms, and reports that you might find useful.

enjoy

 

[jeh]

Thanks for the help.
I know Access has is powerful, but Excel seems to so much easier for me to learn in.

Thank you both very much,

Jim