User input form, retrieves values from query with + or - (or >= or <=) of user input

[0siris00]

I have a form that is used essentially as a means for a user to search for records based on input criteria. This criteria are text boxes that the user can type in text based criteria based on country names. There are also text boxes where the user can input numbers, based on survey results. I want the user to be able to put a number in the form, and the results will include that number plus those that are greater than that number. So if the form says "Input minimum survey results average", and the user puts in "8", the query will return all numbers equal to or above 8: 8, 8.3, 9, 10, etc. How do I set the criteria in the query for this box to retrieve results from the table, via the query, that is >= user input?



Thanks!

[Micron]

If you search on "ms access how to pass form values to a query" you'll get lots of instructions, some like this one

https://youtu.be/bSV1JXFsFaA

[ranman256]

in the query, use the full path to the text box:

...where [field] >= forms!fMyForm!txtBox

(use the BUILDER, it always gets it right!)