Any help / ideas? Searching Question

[lilmikey1982]

I'm having some major problems with creating a searchable db. I'm pretty new to access, and I need to make a database of photos, that I can search by keywords. My original thought was to create a window that would open up, and give you 3 cascading combo boxes of options that would narrow down the photo choices, and list them below in a table embedded in the window. These are pictures of digging sites, so my field names are "Location", "Equipment", and "People". I think that type of a search function will work, but I can't seem to make it function. I'm really new (and bad) at the code stuff, so any help you guys can give, would be MUCH appreciated.

Also, as I am pretty new to this stuff, can anyone think of a way that would be easier to search the photos? The people I am helping, when searching, would like to be able to narrow down the selection. They have about 5000 photos, and the would like to be able to narrow down the choice to about 50. I figured that cascading combo boxes would be the easiest way to do it.

 

[The_Doc_Man]

I agree with you regarding the use of cascading combo boxes. Try to search this forum for some of Hayley Baxter's posts, some of which were related to building a cascading combo box setup.

Rather than re-invent the wheel, I'll suggest you follow that trail first. You can always update this thread to bring it to the top again if you get no joy from that search.

 

[David R]

Please don't post the same thing in multiple forums

cogent1 gave you an answer in one forum, and The_Doc_Man gave you a different solution in another. Personally I'd go with cogent's idea, but the point remains that asking the same thing multiple times doesn't get it answered any faster; it just annoys people and possibly confuses both you and your readers. Now you've got to answer two, possibly three, threads on the same topic.

Try to pick the one topic that best fits your question, and post there. If none seem to fit or it spans different concepts, General is always a safe bet.

Just a tip,
David R

 

[lilmikey1982]

Thank you Doc_Man... that actually helps a lot. I'll go through and look at some of her posts.

 

[Hayley Baxter]

If you send me an email I will forward the samples I have onto you. It will save you the search.

Hayley.Baxter@bskyb.com

Hay