Text Box & Combo Search Function

[expublish]

I need a form with a search facility on it. Simple, you may be thinking ... there is a complication that has thrown me. I need it to be in this format:

[Text Box] [Combo Box] [Command Button]

The text box will be where the user types in the search term they are searching for.
The combo box will list the different areas of the database they can search in. They are: Employees, Units, Jobs, Training, Sickness, Holiday, Disciplinary and Search All. Each of the above is a table with the same name (apart from Search All).
So, the user types in their search term, selects the relvant section to search in and then clicks to command button to activate the search.

How do i do this?

I am guessing I may need to make a query for the search all option. I am thinking i am likely to need a form to display the search results? Does this need to be bound to anything? do I need any other additional queries, tables, etc?

If anyone has this in a database, an example version would be great! If push comes to push I may have to omit the combo, but It would be useful.

Scott.

 

[buckfast]

Scott,
have I look here: http://www.mvps.org/access/forms/frm0045.htm
maybe sort of what you want.
cheers,
Ewen.

 

[expublish]

Thanks for the suggestion. I gave it a go, but it was a little too complicated for what I need. I tried modifying it a bit which made it better but I couldn't overcome the problem that my actual tables and query names where displayed. This is not very professional to the end user.

Anyone know of a more simple example, but along the same lines as the example above?

Cheers again.

Scott

 

[David R]

Make a multi-column combo box, and hide the column with the 'actual' table/query names. Then refer to ComboName.Column(x), where x is the hidden column, counting from 0. Show them the column with the 'professional' names instead.

That might neaten things up for you. You could also use a Select Case statement to choose the proper table/query based on what they choose from the 'neat list'.

HTH,
David R

[This message has been edited by David R (edited 03-05-2002).]