one button, two jobs, done right

[bmoore2187]

I've searched the site to see if my question was already answered, but no luck.
I'm new to the program but i picked it up pretty easy, well my problem starts with a
button that does two things and does it right. well i want my button to send off and email
and input the data into a table (database) at the same time, with the email i want it to send off
a pdf screen shot of the form, for confidentiality reasons, i cannot post pictures. I can get the button to work
but the pdf sends the entire table (screenshot from every entry into the table) and not the current one, is it possible
to get it to send just the pdf I input?

[June7]

Commit record to table first. Then send a PDF of report filtered to that one record. If you really want to PDF the form, then need to filter the form to the one record.

What code are you using for the 'screen shot'?

[bmoore2187]

Commit record to table first. Then send a PDF of report filtered to that one record. If you really to PDF the form, then need to filter the form to the one record.

What code are you using for the 'screen shot'?

i use the build event and start with [EmailDatabaseObject] to get the email to screenshot the form and send it in a pdf, then under that i have the [GoToRecord] underneat to the table that i have setup to put the info into a database.

[June7]

You are using embedded macro? I never use macros, only VBA.

So data is not filtered.

GoToRecord just goes to new record row?

You say macro references table? Not form?

Just did a test. Apparently PDF does include new record even though still in edit mode when output form, not table.

[bmoore2187]

from my job i'm not allowed to post anything on it, but i used the build event, and i believe it sends the email first then the pdf screenshot of the record, but then it adds them all together it doesn't just send the one i'm sending the moment, sends all in the database, if that makes sense

[Minty]

That's a pretty messy way of doing things.
Your button should really create a report in the correct format filtered to the single record, which could be emailed or better still printed to PDF and attached to the email it then generates.