Substitute for Switchboard OnActivate event in A'07 ?

[pooratlas]

When revising a linked table in the '03 database window and then returning to frmSwitchboard, an OnActivate event would occur.
Now, in 2007, leaving the frmSwitchboard to revise a linked table in 'Navigation Pane' and returning to frmSwitchboard does not trigger the OnActivate or GotFocus event.

The event is necessary for running a sequence of delete & append in order to display a summary of the current linked xl.

Short of manually closing & reopening the frmSwitchboard or a 'refresh this form' button, any ideas for initiating VBA code in Access '07, while still maintaining a manual link manager process?

 

[HiTechCoach]

I would use a form to for ALL table edits.

I would also use a command button to first the code, not the on activate event of the form. .

 

[pooratlas]

possibly I was not clear-

I need to refresh a summary subform view of a linked xl.
I need an event to initiate code.

 

[HiTechCoach]

Still not real clear what you are doing from your brief description.

Why not use a command button?