i am currently making a database and need help.
i have made tables with data of lots of people, what i need help on is making a report from what is shown in the current form. in my form at the moment i can view different people and their details, what i would like is a button to click and for the data that is displayed in the form in the fields to be displayed in a report ( i can edit the layout of the report myself). at the moment i can have a report to show every person in my database but i would like it to show only one person whom i have selected in a form.
i want to get rid of having to do the query manually and have it done in the background possibly so that the end user will only ever see the form and the button showing generate a report