Access 2010: Find a record on a form by selecting a value from a list

By using the Combo Box wizard, you can quickly create a drop-down list that lets you find a record on a form. For example, to find a record on a form that displays employee contact information, you might select an employee's name from a combo box at the top of the form, and then the form would display that employee's record.

NOTE: At about 1:35 in the video, I say to click the option, "Find a record on my form based on the value I selected in my combo box". There are some situations where this option is not available. If you don't see that option in the dialog box, you can get a workaround by going to http://bit.ly/bxAUsd and then clicking the line, "The Find a record... option is not available."

Category:

Howto & Style

Tags:

• Access 2010
• database
• find

[knanglia]

Hi

I don't see the third option when the create box wizard opens. What could be the possible reason??

Also, you mentioned this won't work in a web form. What's the best/easiest way to search for a particular record in web form then?

[cdowns63]

Hi knanglia, you can get a workaround by going to bit.ly (slash) bxAUsd and then clicking the line, "The Find a record... option is not available."

For finding on a web form, I'd recommend downloading the Contacts Web Database template (available on the File | New menu in Access 2010, or on Office.com), and exploring how the search box works on the main form. You might be able to implement a similar search on your form.

--Chris

[txvivian2008]

hi, can you please tell me how to create a query to find customers or people who do not live on a certain street, city, or state?

[txvivian2008]

hi, can you please tell me how tocreat a query to find customers or people who do not live on a certain street, city, or state?

[knanglia]

@cdowns63 Thank you so much for the help.

I think i am gonna go with your advice and check out the contacts template.

[geavrc]

hi, can you answer this question maybe? I use Access 2010. I have a table with 6000 records with only one (unique ) field Emailaddress and I want to make 20 tables of tgat with 300 records each by selecting every 20th record and MOVE those to a new table. How can I do this? Thx in adavance for your answer. G

[jordoe93]

Great Vid!

The only problem at me is that i haven't the 3th option in the first pop-up window. All the other windows are the same as yours but when i'm finished he doesn't link the name of a hotel, in my case, with the other records. So it's just a drop-down list with no record search. I Hope i have explained it good enough for you and maybe you know what i can do.

Thanks in advance!