RESUBMITTAL - Send New Record Only

[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?

 

[John... Visio MVP]

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?

What does the relevant code in the OnClick look like?

John... Visio MVP

 

[Lyne Savage]

It's a Macro...my training for Access has not yet begun (next week) and I'm
jumping the gun a bit...

 

[Gina Whipp]

Lyne,

The key to sending *the new record* is determining how Access knows it's a
new record. Which sounds like what is missing. Please post the Macro
Actions. Also, is this and unbound form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Lyne Savage]

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...

 

[Gina Whipp]

Lyne,

You can base the Macro on a query and add a Where Condition to the query...
e: Forms![FormName]![NameOfKeyThatWOuldFiltereMailMessage]


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[KenSheridan via AccessMonster.com]

A further point is that the macro should ensure that the current record is
saved (by calling the RunCommand action with the SaveRecord command) before
calling the SendObject action. Otherwise if the user has just entered data
for a new record in the form the record will not yet have been saved to the
table, so a query would not pick it up.

Ken Sheridan
Stafford, England

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...

Lyne,

[quoted text clipped - 23 lines]