Bill

I'm a bit unclear still...

Your description said, roughly, "it didn't work". That isn't much to go on
in helping you troubleshoot.

You have a table that has multiple rows. You want a way to send what you
are calling the "current record", apparently based on what is being
displayed in a form.

I would approach this by building a query that refers to that form's record
ID and returns the field(s) I wanted. Then I'd build a command button that
attached the output of that query to the outgoing email.

For the query, I'd open up the form and select a record, then use the
database window to create a new query. I'd select the RecordID field and
?some other field. Under the RecordID field, in the criterion, I'd add
something like:
Forms!YourFormName!YourRecordIDField
(your syntax may vary). Then I'd run it, to see if the query works.

For the command button, it sounds like you've already set up one that works,
just takes the whole table. What happens if you build the query above and
then send the query?

You don't mention where the command button is located, but your earlier post
mentioned two forms. I hope the command button is on the form from which
you wish to send the record.

--
Good luck

Jeff Boyce
Access MVP

"Hulk" wrote in message
...
Jeff,
I have a table called Memos that the user enters information into only
on an add form, when they have added the information I want a query
command
button so that they can e-mail only the information in the current form,
no
others. I build a command button for e-mailing with sendobject but it
send
the whole tabel in forms. I only want to sent the current record.
They suggested way to build a command button but it had many lines of
code and it didn't work. I have tried and tried but building a query to
show only the current record which had just been added seems like a way
around the problem. It hasn't happen. The table has an autonumber which
it
uses as the ID, the query uses the information from the main table of
"memos" and with the ID as a reference I want to show that information in
a
form called "current form" which will have a command button on it to
e-mail
just the current form. I can't make it to simple, and code just doesn't
seem to work, I'm just a novice.

Thanks
Bill
"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
Bill

Why?

You've described "how". Perhaps the 'group readers can offer you an
alternate approach if you explain what problem you are trying to solve
by
passing information to a second form...

--
Good luck

Jeff Boyce
Access MVP

"Hulk" wrote in message
...
Is there a way to put build a query to accept only the current record
from
another form? I want to use the autonumber to show only the record
showing
on the screen and need to build a query to pass that information into
another form.

Thanks
Bill