Form showing results in between two numbers (1 Viewer)

I'm building a database that contains error codes and the starting part number and the ending part numbers effected. The part numbers are continues, they go from 0 to 120. The number of parts is too large to include all of them in one table. So, I have a made a form that has a text box where the user enters a part number and a subform table will show any records that have that part number between the starting and ending part number. I tried to do it in VBA but I couldn't get the code to work. So I'm trying to do it with a query.

I have a query which will use the text box in the form as a criteria but I can't figure out how to make the criteria less than and greater than.

I've tried the statement below but do not get any results.

WHERE ((([Forms]![Table1_frm]![Search])>=[StartingPartNum]));

Thank you in advance.

The number of parts is too large to include all of them in one table.

Click to expand...

Why do you say that?
Access tables can contain millions of records without problems.
The only limit is that the overall database size cannot exceed 2GB

As for your WHERE statement it needs to be based on the table / query name used in your form
You can either use
or

see your query and the macro behind query button.