Form using "From" and "to"

[Hugo]

Hi, I want to create a form to open a report, so that I can choose "from" a customer "to" another customer. For example I got customers A,B,C,D,E and I want to be able to choose "from": C "to":E and got only those customer on my report........ I've created a form already using combo boxes, but I do not know how to make work to look up the values "from" and "to"

 

[JJordan]

I think you need to start with a Query that gets the data you want from your table with a Between clause in the Criteria for the Query. You can link the criteria to your form as follows:

Between [forms]![yourformname]![FormFieldNameForStart] AND [forms]![yourformname]![FormFieldNameForEnd]

This will cause your query to pick up the two parameters from your form. You can then create a report from this query and link a Button on your form to Open the report.