Help with report

[associates]

Hi,

I was wondering if anyone would be able to help me here. I have a form that has a combobox that contains a list of students and a button 'Go' that would produce a report based on the student selected on the combobox. My problem is say i have selected studentA from the combobox and press button 'Go', a report is then brought up with all the details in regards to studentA. If i don't physically close this report and then i go selecting a different studentB from the combobox and press button 'Go' again, the report doesn't get updated or changed to show details of studentB. What should i do to get the report to get itself refreshed?

Hope i explain it well.

Thank you in advance and look forward to hearing from you

 

[edtab]

Try putting this code in the after update of your combo box.
It should close the current report on the screen without
any further action on your part. After that, clicking your "Go" button
should bring up the new report.

DoCmd.Close acReport, "YourReportName"