I am using VBA and I am having a little trouble emailing a report.

Basically I have a single form that the user inputs data through and is then saved into a table.

I also created a report which is identical to the form in appearance and this report is what I need to have emailed.

I used a macro and have no problem emailing the report as a snapshot with data from the table.

The problem I am having is the report is ONLY using data from the first record in the table.

On the form is a command button that the user clicks in order to email the report after they key it in. How do I get this command button to email the report with the current information they just entered?