How to store informatin in another table if button is pressed and record key presses.

[SGT]

Hi all,

I have a form called (frm_process_premos_popup) with a button (cmdNotifyMember) that when pressed, it sends an email to the member letting him know that his information was updated.

If I press the button (cmdNotifyMember), it must store the date and time in another table (tbl_email_count) in field ([dateemailsend]).
It must also store the paynumber ([paynumber]) of the member on form (frm_process_premos_popup) to (tbl_email_count) in field ([emailsendto]).
It must also count the number of emails sent to that specific member and display it on the form (frm_process_premos_popup) basically record key presses.

Hopes it makes sense.

[ranman256]

in the button on click event (in addition to the email)
run append query to store the event
run append query to store the paynumber (the query uses the form txtID to append)
then run : txtCount = DCount("*",[personsEmail]) , to load the persons email count.

[SGT]

Sorry, can you be more specific please. What is append query?? I am still learning access.

thanx for the reply so far.

[ranman256]

Append query adds data to the table
Use the query wizard to built one.