I built a database that keeps track of the school employees went to and the date they completed the school. i have built 3 reports. one called "byemployee" which shows just that employees info. another is called "byarea" which shows all the employees in that area and the schools they went to and date. the last one is called "byschool" and shows a list of everyone whose been to that school. i have created just one querie for all the reports. i made a form called "generatereport" that will prompt the user to select the area, school name or employee name to base the report on. i declared a public variable called "reportoption". on each report there is a number. example: report based on employee is reportoption 1, report based on area is reportoption 2 etc. when the user clicks on a report the report will load the form "generatereport". so if the area report is clicked on the "generate report" form will open and display only a combo box with a list of areas to allow the user to select an area. if the shool report is clicked then the "generatereport" form will display only the school combo box etc. the problem i am having is that after i view a report the form will not reset itself unless i completely close out of the form and reopen it. for instance if i click area the form will load up appropriately but if i close the area report and click on the school report it will still load up the form with only the area combo box. it seems to work fine the first time but then after that i have to completely close out the generate report form and reopen it so it resets itself. does anybody know what could be causing this?
Not sure if problem is report or form
- Thread starter huertalm
- Start date
Similar threads
