Updating Subform

[TKnight]

Hi, I have a combo box on a form that lists team names. When you select a team name information relating to that team appears on the form as well as a list of e-mail addresses (in a subform) that reports get sent to. I used a union query to insert "Add New" as one of the rows in the combo box and when a user selects that option it opens up a pop-up that allows the user to add a record to the team table which the combo box is based on.
In the close event of that pop up I requeried the combo box which makes it pick up the new team name fine. I also requeried the subform. The problem is that the subform that is linked to the combo box doesn't respond when you select the newly added team. If you pick any other team it links ok but if you choose the new team it displays the records relating to the team that was in the form before "Add New" was picked. I know there are no records for the new team because it's just been added but I need the subform (continuous) to clear itself ready for input.
If you close the main form then open it up again it works fine but i'd really rather not do this even in code. I've looked into all the "re" methods and none of them manage to update the subform properly.

Can anyone help?

Thanks Tom.

 

[Michelangelo]

Nevertheless, I think a requery of the subform should do the trick. Call it from the same code as the add new is performed, or on the current event.

so something like:

me.subform.requery

HTH

M.