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

[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]

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

[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!