I'm trying to create a form in which you can search through a table based on two specific parameters (name and date), and once you find the entry you want you can press a button to generate a report from that table. My question is eventually going to regard how to generate a report with a button.
I first created a query with just the name and date variables from the table in question. I then used a split-form to create a basic search command button which allows the user to search and select an entry based on name/date. Now that I have the correct selection, how can I go about generating a report based on that entry?
The full table obviously has far more variables than what are included in the query, and so does anyone have advice on how to use the selected values to reverse-search the data in the table? Also, I have not had experience auto-generating reports before, and so are there any good tutorials on how to link the structure/style to a command button?
I'd appreciate any advice you all can offer!