Query based on a form which had field names and some values

[virencm]

Hi guys,

I have a table listing about 20 elements as field names eg FE, CR, NI, TI and so on.
I have built a form which has a combo box listing these elements by selecting "fields" in the property settings of the combo box & next to this combo box i have 2 text box's where the user can input Min & Max values to pass on to the query.

eg FE (chosen from the combo box) value between (Text box1) and Text box 2.

I can run the query to give me values between the 2 text box's by using the following formula in the criteria (Between textbox1 and textbox 2).

The issue i have is to be able to select the element from the listbox, input the min & max values identified and be able to pass this to a query so the query can filter based on the field and values passed?

Can someone help please?

 

[pr2-eugin]

So where are you stuck? You seem to have got everything in place. Show the Query, is it working? Is it showing any error?

 

[virencm]

Hi,
Thanks for your response. I have attached the database.
There is a note on the main form that explains what i am trying to do. I hope it makes sense.

cheers
Viren

 

[virencm]

Sorry here is the attachment