text box button query to generate a report

[chrisoreillyuk]

Hello all

i need to create a text field and button in a form that will show all the records for a particular JobNo in a report once the txt has been typed and the button is clicked, i.e if I type JobNo001 I need to to create a report showing all the information for that JobNo(but there can be multiple JobNo's).

Do i have to create a query for this. I am new to this so please be gentle

Thanks

Chris

 

[FoFa]

A single job number is easy, you can reference the form field in your criteria in a query to feed a report. Multiple values, well then you need to revert to VBA usually.