SendObject not working first record.

[Bopsgtir]

Hi all, im sure this is something very simple but i cant work out whats wrong.

I am very new to access, i have a form that on Load runs the GoToRecord macro and selects new which should mean im ready to enter a record, at the end is a button to email that record to whichever department needs it. my problem is if you open the form and fill out the data, the email attachment is always blank just with the field names, if you go back into the form and actually click the new record button and fill it out it all works fine. any ideas.

 

[missinglinq]

Sounds like you need to save the New Record before the email is sent. In the Code behind the Command Button used for sending the email, before any other Code, place this line:

DoCmd.RunCommand acCmdSaveRecord

Linq ;0)>

 

[Bopsgtir]

That was exactly it, all working now.