Get user input and generate a report

[dcorleto]

I have a table linked to an excel sheet. Have run a Query that selects only the fields needed and returns all records. Would like to have a form that the user can input up to 10 employee numbers, and have the query run and return only those records that were input by the user.

I know this is probably basic stuff - how do I begin?

Thanks in advance.

 

[randy700]

Why not simply add a WHERE clause to your query?

WHERE EmployerID IN ([i]List of values here[/i])

Randy

 

[dhookom]

Check the list box information in the FAQs for this forum.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]