Make sure table gets data from form before close

[H0MELY]

Greetings, thank you all for looking. This is probably very easy but it is
late and I am having brain problems. I built a quick "issues" form that
allows people to enter information when they encounter problems with my
databse. Hopefully it will never need to be used

So I have them click a button that will always be available from the form
header. The button opens the issue form ready for a new record. The data
that is entered gets posted to a table called...tbl_issues. The issue form
has a submit button that uses the sendobject action to send me an email of
the issues table.

So the trick is that the user must complete the record and move on to a
potential new record for it to get to post to the table. My question is...I
would like to ensure that the data that is entered gets posted to the issues
table...regardless if they actually complete the form. If they click the
send button I want whatever is in the data fields to get posted to the table
and then sent to me.

I hope this is really easy for someone. Thank you all for looking and I
look forward to your responses.

-john

 

[Wayne-I-M]

If the form is bound to a table - as soon as the record is created anything
input in the controls (bound to field) will be stored in the table. You
don't need to do anything. Of course if they delete the data in the controls
then you will not save it but the record will still be saved (unless they
delete the record)

You just need to create a report (filtered that the record primary field)
and use SendObject to send this report to you in whatever format you have set.

 

[Wayne-I-M]

Have a look at this link

http://www.lebans.com/mousewheelonoff.htm