A Search Form

[badangel]

Hi everyone,

I'm trying to create a search form for my database and would really be grateful if someone could give me a few pointers as to the best way to go about this!

I would like a form with a number of options the user can search by on the left side then have a sub form on the right displaying the results of the search. The search bits would be both drop down menus and text boxes with find buttons and I think I know how to do this bit by using code in the onclick event.

The subform would be a tabbed form with the tab displayed according to the search option which had been used and the other tabs obviously displaying relating information to the selected entry.

I know I haven't asked any specific questions yet but I really just want to find out if this is the best way to do a search type form or is it too complicated?! Also I'm unsure as to which bit to create first and how to connect the two together!!

Thanks in advance for any help offered.

 

[Mile-O]

Have a look here.

 

[badangel]

Thanks Mile-O, that's definately got me on my way. I appreciate it!

 

[Autoeng]

For very complete pre-built search utilities try the RFil and FFil at www.mile50.com

Autoeng

 

[goaksmith]

www.Mile50.com

I went to this website and downloaded the prebuilt search utilities and it is great! It was super easy to install and even easier to update and use. It is great. I recommend it to anyone. Especially if you don't want to write your own code.

 

[Autoeng]

Because you can put in the qualifiers (and/or/is not) I don't think anyone has ever come up for the code to do that yet. Makes it even better.

 

[goaksmith]

I was actually amazed at how complete it was. You can pretty much search for anything in any way. Fantastic!