Append Messages

[Erin]

I have a form, frmAttendanceTrack, that allows the user to enter a record
when an employee uses vacation time, etc. The user clicks on the "submit"
button to run an append query and append that new record into a table. The
"append messages" are hidden from view.

There is a button on frmAttendanceTrack that allows you to get a "quick
reference" of how much vacation time an employee has left. If you click that
button, a small form opens that allows you to look at employee records.

PROBLEM: For some reason, if you use the "quick reference", then close out
of it and try to submit an attendance record from frm Attendance Track, those
dumb "append messages" pop up again!

Why does this happen and how can I fix it??

Thanks!

 

[Daryl S]

Erin -

Search your code for "SetWarnings". We normally turn them off before
running action queries, and then turn them back on after running them. It
looks like they are turned back on in the "Quick Reference" piece, which is
probably OK. It could be you turned them off in the OnCurrent or other form
event, but they should have been turned off right before calling the append
query. You will need to adjust where these statements are. They usually
look like this:

DoCmd.SetWarnings False (or True to turn them on)