I have a form I use for student academic progress. I have another form that I use for class management issues (discipline, etc). I have a command button on the academic form to open the mangament form. I want the management form to open with the student's name and other similar data already populated with the data from the academic form.

A second issue is that when I fill out a management form, I need to send an email to the administration with the management issue. I would love to have a command button on the management form that generates an outlook email with the CURRENT record only. I have a button that sends an email, but it does so on a user-input query. Not efficient in my book. I only need the current record which is already open.

How do I do this?