Email failure

[SteveE]

I have some data which is sent from my DB using send object this works great but only once ! if I select another record the send just fails does nothing. I know that by closing my DB and reopening all is well again its as if something is making the code hang and closing resets this any advise appriciated. (A2K and Outlook email) also could anyone advise the syntax to refer to controls on a sub-form
thanks in advance

S

 

[boblarson]

You might want to post your code for the email part so we can look at it.

The syntax for referring to a control on a subform is:

Forms!YourMainFormNameHere.YourSubformCONTROLNameHere.Form.YourControlNameHere

Make sure that you use the subform CONTROL name and not just the subform name. It is highly probable that they are the same, and that's okay, but if they aren't you have to refer to the subform control that houses the subform on the main form.

 

[pbaldy]

Could be this, since it runs once:

http://support.microsoft.com/kb/260819/en-us