Is there an event for this?

[mscertified]

I have a form containing a command button. When this button is clicked, I
display a popup form which collects some information that is written to a
table.
When the close button on the popup form is clicked, I return to the original
form. When I return to the original form I have to add a new tab to a tabbed
control with the content determined by the records that were added on the
popup form.

I'd like to code this in the code for the original form but cannot find an
event that fires when control is returned from the popup form. Any ideas?

 

[Jeff Boyce]

I'm a bit unclear what you are trying to do. It sounds like you want your
form to dynamically add a tab to a tab control when you've used your popup
to add a row/record. This approach would be very unusual and could turn
into a maintenance nightmare if you added more than a few new records via
that popup.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mscertified]

The Activate event is not firing. The popup form has popup=yes, model=yes.

If I open the popup form in dialog mode, then control drops to the statement
below when the popup form closes, so I can put the code there. I'm not sure
what else dialiog mode affects.

 

[Klatuu]

It is the Form Activate event.
It will fire after the Load event when the form is opened, then if you move
to another form and back, it will fire each time this happens.