L
Larry06Green
I'm trying to code for two command buttons on a form used for data entry. The
first button named "Add Project" would add a record to the database and then
prompt the user with a vbquestion as to whether or not they want to add
another record or not. If yes, provide a blank data entry form, if no, then
close the current form and return to the main menu. The second button named
"Add Project Send Email" would perform a number of tasks which include adding
a record to the database, prompting the user about adding another record or
not, running select queries to identify the newest record in the database and
outputting that record to a form which would then be referenced in a
SendObject statement to email the record information to someone in another
department. Can all of this be done with just two command buttons? One
button should just be used to add a record and the other one used to add a
record and send email notification.
first button named "Add Project" would add a record to the database and then
prompt the user with a vbquestion as to whether or not they want to add
another record or not. If yes, provide a blank data entry form, if no, then
close the current form and return to the main menu. The second button named
"Add Project Send Email" would perform a number of tasks which include adding
a record to the database, prompting the user about adding another record or
not, running select queries to identify the newest record in the database and
outputting that record to a form which would then be referenced in a
SendObject statement to email the record information to someone in another
department. Can all of this be done with just two command buttons? One
button should just be used to add a record and the other one used to add a
record and send email notification.