Reloading a subform

[gibsonn]

Hi all,

How do I reload a subform without leaving? Reason being is that I am deleting a record in the after insert event of the form and when I click on another tab/button whatever it comes up with deleted all the way accross. What would be ideal is that when the event is triggered is to re-load the form, which should get rid of the deleted columns and setfocus to an object within that subform.

Any ideas.....

 

[Mile-O]

Two ways (from the parent form):

• requery the subform object;
  

  Me.[i]subformObject.Requery[/i]

• reassign the subform object's SourceObject;
  

  Me.[i]subformObject[/i].SourceObject = "subformName"

 

[gibsonn]

Thanks for replying the requery method worked fine. Just one more thing how can I get the focus to remain on the object I have just changed once I have clicked on a tab/button etc outside of the subform?

 

[Mile-O]

You can't...the form and the subform are two different objects; there is only one focus so either an enabled control (or the form if there is no enabled control) on the form gets the focus or, likewise the subform object.

You can use the SetFocus method to set the focus to a specific control though.

i.e.

Me.[i]subformObject[/i].Control.SetFocus