Our school district provides Thinkpad's to approximately 20,000 students. I have a database that pulls student records from an AS400 and a SQL database, and allows the student to enter a repair request in through Access. The student selects their name, and Access fills in all their student information from the linked databases. The student then enters the problem they are having and submits this via email to the tech for their school.
I don't want the student to be able to view the report because it will contain their student ID, which needs to remain private. The student, of course, knows their student ID, but other students standing nearby will be able to see it.
I need a button at the bottom of the form (frmRepairRequest) to email a report (rptRepairRequest) to the school tech. The report is based on a query (qry123) that contains a field with the tech's email address (fldTechEmail). After the email is send, a message box (which I know how to code) will display a blurb about "your request has been sent, etc.". Clicking "Ok" will return the student to the name selection screen for the next student.
I'm sure it's possible to do this, but I'm in over my head in knowing how. Any help you can give me will be very much appreciated.
Thanks.