Ok. I have a pretty good sense on using Access, but I have a question that has been baffling me.
I have a main form with a few subforms and want to be able to a have a button that will e-mail a specific person or department with the details of the data in the form before the form is written into the table (if possible) since the data is written to different tables at the same time therefore making it hard to sort the the correct data from a particular record.
I have read some places on this forum on how to create the button to send the e-mail, but it assumes that the data was already written to a record already.
Let me know if there is a way to do this or if someone can direct me in the right direction. Thank you very much as any information is greatly appreciated!
I have a main form with a few subforms and want to be able to a have a button that will e-mail a specific person or department with the details of the data in the form before the form is written into the table (if possible) since the data is written to different tables at the same time therefore making it hard to sort the the correct data from a particular record.
I have read some places on this forum on how to create the button to send the e-mail, but it assumes that the data was already written to a record already.
Let me know if there is a way to do this or if someone can direct me in the right direction. Thank you very much as any information is greatly appreciated!