Query with data from form

[gmaster]

Hi, i have a form with a combobox and a text field, and i want to make a query that search those two values (the one selected by the user in the combobox and the one written in the text field) in a specific table...How can i do it??


Thanks!

Edit: there's another issue...those two values should be searched in multiple fields, i.e. the combobox should be searched in column1, column2, column3 and the textbox in column4, colum5, column6

[pbaldy]

Generally speaking you put a reference to the form control in the criteria portion of the query builder. The desire to search multiple fields could indicate a normalization problem. To do it you'd put the form reference under each field. Putting them on the same line results in an AND comparison, on different lines results in an OR comparison.

[gmaster]

Yes, thanks!!!!!

[pbaldy]

Happy to help!