Another Subform Requery Question

[utdel]

ok i've looked through the archives and still don't get it. here is my problem.

I have a main form which is linked to a subform. on the main form i have a combo box that list players name. when a players name is select the associated player cards are displayed in the subform(main data only). now i also have an add cards button on the main form which will allow the user to add more cards for the selected player on another form which it opens. now here is the problem. after the user adds cards and closes the add form and returns to the main form with the subform, it does not display the newly added cards.

i have added variations of the following statements on the on_current event of the main form without success:

Me.Cards_Subform.Requery
Forms!players1![cards_subform].Form.Requery

any help would be appreciated.

please help out this Access newbie... again thanks in advance.

 

[Okie]

Try putting that same code in the On Close event of the form that your adding a new card to.

HTH
Shane

 

[DBL]

Try on the OnActivated event of the main form.

Me.refresh

 

[utdel]

thanks DBL it worked. again thanks to all who replyed. hope to return the favor one of these days. thats if i get as good as you guys.