DoCmd.SendObject

[fredgc2008]

I am perplexed at this command; I am using to send a "form" with 12 fields that user must fill. All is well and it sends email(as it should). However, the email received shows 12 copies of the record. The code is as follows;

DoCmd.SendObject acSendForm, frmUserRegister, "HTML(*.html)", "fredgaribaldi@cox.net", "","" ,TRUE , ""

Any help would be appreciated.

 

[Remou]

I would guess that there are twelve records. Is this not the case?

 

[genomon]

Rem is the expert here as I only use forms for front-end stuff. Just wondering if the "continuous form" property setting would make any difference?

"Business conventions are important because they demonstrate how many people a company can operate without."

 

[fredgc2008]

Remou,

You are correct, there are twelve records. Is there anything to be done for this not to happen?

 

[Remou]

I have not tested, but I think a filter should work. Set the filter so the form includes only the current record and remove it after you have sent the form.