Use a combo box to pull up a form? (1 Viewer)

I'm hoping this is the correct section to post this. I am talking about forms

Anyway, I've googled, googled, and googled for this but I just can't find what I'm looking for. I'm creating a "phone book" for myself. Keep track of hundreds of contacts. Of course, I'm not the only one accessing it. I'd like to create a combo box where I can type, say, a last name. I type it and hit enter, it brings up a list of people with that last name. Or it could bring up a form of the first person with that last name.

If there's another way than combo boxes, please let me know. I'm only talking about them because that's the only way I can think of.

If there's anything with directly putting in code and not using a wizard, PLEASE be as informative as possible as I've only been working with Access for a short time.

Thanks.

Interesting, I created a sample mdb for someone last night. They had a problem with duplicates in a different context.
In my sample, there is a staff table (could be contacts)
and a form. The form has a list box (with staff names) and a textbox.
In the textbox, you put the name you're searching for.
As you type, it updates the list box with similar names
When you stop, the list box will contain one or more names (staff)
Doubleclick the name in the list, and a new form with StaffDetails opens


I've attached it ListBoxDup.mdb acc2003 format.

You could modify table or forms as you need.

Good luck.

jdraw said:

Interesting, I created a sample mdb for someone last night. They had a problem with duplicates in a different context.
In my sample, there is a staff table (could be contacts)
and a form. The form has a list box (with staff names) and a textbox.
In the textbox, you put the name you're searching for.
As you type, it updates the list box with similar names
When you stop, the list box will contain one or more names (staff)
Doubleclick the name in the list, and a new form with StaffDetails opens


I've attached it ListBoxDup.mdb acc2003 format.

You could modify table or forms as you need.

Good luck.

Click to expand...

Having a bit of an issue. How would I go about editing it to fit my needs? Basically, I have a button on my startup form that would open the search form. I have a single table with FirstName, LastName, phone number (home, work, and cell), releationship, and so forth.

Thanks!