Help with Search buttons and forums

[Filmnoir]

Hi All,



I'm struggling to create a search function within a form. I've looked at the examples on the forums and they are either to complicated or haven't worked.

I'm trying to use 'Search' Form to look for 'Consultant_Name' in Query 'Skills_All_Search'. Once clicked it will display the consultant record in 'Search_Consultant_Form'.

Also I want to be able to add to 'Search' Form drop downs for all the remaining fields in 'Skills_All_Search' (For box Choose Consultant Skills) and/or the value (Either B;I;E) of the fields.

This search function should pull just the list of consultant names for the criteria picked.

[rpeare]

Your database is in trouble. You should have a table that lists all your personnel and that table should have a primary key, that primary key should then be your search field which can be selected with a combo box. Typing in people's names into your skills table is a bad, bad, bad idea.

Here's a copy of your database back with a consultant table. The LIKE statement in your query will show ALL records if no person is chosen and only select the chosen person if there's something on your SEARCH form. The same method can be applied to the other fields in your search

[Filmnoir]

Thanks, funny enough I had a second table like you recommended, but took it out as I was having trouble with the search. I'll have a look and see how I can change and add to it. Thanks.