Help with query on form!!

[hullstorage]

i use a form based on a query which call all records that have not been invoiced

what i want to do is query these then in the form i have a field that when i enter a number and click on a button it gives all the records below this number in the field invoice no

any ideas

 

[PaulO]

I think what I would do is build an additional 'filter/selection' form to work in tandem with your select query ... the appropriate field in the query being modified to utilise the data entered/selected in the form field to filter its output into your existing form.