I have a data report and I want to be able to keep the application open and still run reports for different people.
Currently I run the report, it brings in information from Access through data environment. My connections are not in code. There is a button that requests the user to enter two peices of information through input boxes. Then the application brings in the information to the report. When you click the button again, it will go through the morions and the correct information gets written to the database but when the report appears it is for the first person entered.
I need to be able to run the report for one person, print it and then run the report for the next person without having to exit the application in between.
Please help! Could you also tell me where the code would have to go in my report. For example, I have a main form and trhe data report. Does the code have to go under the data report or under the button that displays the report?
Thanks in advance for your help!
Currently I run the report, it brings in information from Access through data environment. My connections are not in code. There is a button that requests the user to enter two peices of information through input boxes. Then the application brings in the information to the report. When you click the button again, it will go through the morions and the correct information gets written to the database but when the report appears it is for the first person entered.
I need to be able to run the report for one person, print it and then run the report for the next person without having to exit the application in between.
Please help! Could you also tell me where the code would have to go in my report. For example, I have a main form and trhe data report. Does the code have to go under the data report or under the button that displays the report?
Thanks in advance for your help!