| | |
|
|
|
forms and outlook - help |
|---|
| message from anonymous on 26 May 2004 |
I have a database and use a form to enter the data. When
the client has entered new records he would like to e-mail
it to others. Here's my problem, I added a command button
to run sendobject, which works except it attaches the
whole database. I only want to send the new record thats
visiable on the form. Is there a way to do it.
Any help is appreciated
Dale
|
| Cheryl Fischer replied to anonymous on 26 May 2004 |
Create a Query based on the table which is the record source of your form
and include in that query all of the fields your client wishes to send to
others. In the Criteria: row for the field which is the unique
identifier for the record, insert the following:
Forms!MyForm!UniqueIdentifier
This will work presuming that the record has been saved and if there is a
control on your form which is bound to the UniqueIdentifier field in your
table. You can then use SendObject to send the Query.
|
|
Archived message: forms and outlook - help (Microsoft Access Forms)
