searching, editing parameters and criteria- at once!

[poolz]

in my database i have three tables. two of these tables ( occupation and qualifacation) are related to the original table, table2. the two "daughter" tables are designed to give cirtain field entries a "code" number for easy entry and look up of records. the problem i have is that i need to create somthing that will search table2 using three fields from table2, and the "code" numbers from the occupation and qualifacation tables.

i have set up a query that has several criteria which serches using the code numbers and also serches the three other fields from table2.

this, in theory is what i want- but not quite. i have made it too complicated, it doesn't like it and says " this expression is too complex to be evaluated. It also askes me to enter every parameter value one after each other, thats five different boxes for five questions. is there any way to get these questions into ONE box where any number of parameter value fill-in-boxes can be filled or not? i also then want the results to be displayed in a form.

i know this is very complicated, i don't know what to with it.

I am willing to start again, i'me tring to use somone elses work. I need however to be able to serch my data (in a table)using two sets of code numbers, and three normal fields, all of witch must be displayed in a form and be set up for someone to come along and fill in five fill-in-boxes in one pop-up perameters box.

if anyone can tell me clearly what to do it would be much appreciated.

thanks

 

[jatfill]

For starters, I would temporarily eliminate the query criteria and simply build the query itself to pull the information you need correctly. This way you know the query itself starts out solid.

Once the query is giving you the results you need, then start looking at the criteria portion. The easiest way to do multiple parameters is by first building a form and thenbasing the query's parameters on values entered into that form.

If you could post or send an example, I don't think this would be too difficult to fix.