Dynamic refresh of form

[jle0003]

I have 2 forms, frmEvent and frmEventList. A user opens frmEvent to create an event and save it. The frmEventList shows a datasheet view of all events. Both forms can be open at the same time. What I wouldlike to occur is when a user creates a new event on frmEvent and saves it, then the frmEventList is dynamically updated. Currently you have to close frmEventList and reopen it to see the new Event in the list.

Please help. Thanks!

[pbaldy]

You should be able to requery the second form in the after insert event of the first.

[jle0003]

Thanks, but this did not work. Any other ideas?

[pbaldy]

Can you post the failing db, or at least your code? Requerying the form should work.

[jle0003]

Here is a sample db

[jle0003]

Sorry, I think the last attachment was not working correctly

[pbaldy]

I don't see the attempted requery offhand. Am I missing it?