RESUBMITTAL - Send New Record Only

  • Thread starter Thread starter Lyne Savage
  • Start date Start date
L

Lyne Savage

I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data entry. On
the OnClick option of the sumbit button,I would like to have the record that
was just created sent to someone by e-mail. Right now, I can only get it to
send the whole table, but I would like it to send only the last record of
that table. Is this possible?
 
Lyne Savage said:
I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data entry.
On
the OnClick option of the sumbit button,I would like to have the record
that
was just created sent to someone by e-mail. Right now, I can only get it
to
send the whole table, but I would like it to send only the last record of
that table. Is this possible?
Click to expand...


What does the relevant code in the OnClick look like?

John... Visio MVP
 
It's a Macro...my training for Access has not yet begun (next week) and I'm
jumping the gun a bit...
 
The macro is made with SendObject...which sends the table that the form is
bound to. I don't know how to create a macro that will send only the new
record...
 
Back
Top