form to insert into db and email with submit command

<i><b>Originally posted by : Darek (dcleslie@partners.org)</b></i><br />I know how to create a form to send an email and also to insert records into a database (I'm currently just using Access 2000, and I'm using iis) - but how do I make the form insert a record into access and email at the same time?<br />The form will send an email to me from the user to request something. I would like these requests logged into access for future reference.<br />Please help!<br />thanks,<br />darek

<i><b>Originally posted by : sree (balerao_s@yahoo.com)</b></i><br /><br />Hi ,<br /><br />I think its better to call Email function after the insert operation.<br />Hope this will solve the problem<br /><br />------------<br />Darek at 5/2/2002 8:31:59 AM<br /><br />I know how to create a form to send an email and also to insert records into a database (I'm currently just using Access 2000, and I'm using iis) - but how do I make the form insert a record into access and email at the same time?<br />The form will send an email to me from the user to request something. I would like these requests logged into access for future reference.<br />Please help!<br />thanks,<br />darek