forms and outlook - help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One possibility that comes to mind:

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