From: John W. Vinson on
On Mon, 29 Mar 2010 15:27:21 GMT, "SFleming via AccessMonster.com"
<u58990(a)uwe> wrote:

>John - Thanks for your help...I hate to ask an elementary question, but would
>you place this event proceedure on the subform attached to one of the field
>or some type of an update button?

That's up to you. You know better than I do how you want your user interface
to work!

It should be in the same code that executes the append query. I'd assume that
would be a command button on the mainform, but there are other ways you could
do it (the AfterUpdate event of the mainform, or some control on the
mainform).
--

John W. Vinson [MVP]