How do I create code for a command button that will add 2

[kat25]

Hi,
I've got a form that I want to add a command button to that will do the following:
1. open a new record
2. save the record to the fields defined in my table.
3. always show a new record each time the user clicks on the command button.

MY problem is that my command button creates a new record after I save the previous record, however, the next time I
open the form, the 1st record is displayed instead of a
blank new record.

Many thanks for any suggestions.
Kat25

 

[FancyPrairie]

In the OnOpen event of the form, try this:

Docmd.GoToRecord ,,acNewRec

 

[kat25]

Thanks FancyPrairie!
That worked great.

One more question. Now that I have a new record, I want to
type in my values and then send an email using the sendobject method.
My problem is that in my current code, I open the form and then use the sendobject method, however this does not allow my form to remain open long enough for me to type in the values before the sendobject event occurs.

Any thoughts.
Again, thank you.

 

[FancyPrairie]

You'll need to be more specific. Are issuing the sendobject command and then closing the form?

 

[kat25]

Yes, I then close the form. My steps are:
open form
sendobject
close form

Thank you.

 

[Blanch]

Here is a sampel of code that works fine.

Private Sub cmdEmailClose_Click()

With DoCmd
.SendObject acSendTable, "Shippers", acFormatTXT, "jim.blanchard@tycohealthcare.com", , , "TEST", "BODY", False
.Close
End With

End Sub

Hope this helps.

Jim Hope this helps!

Jim

 

[kat25]

Thank you for your time and help.
I will give that a try.