Update ControlField for Subforms on Load

[Meanfish]

Hey Guys and Gals,

I've been working with Access 2007 for about 2 1/2 weeks now, Here is my question.

I have a Form 'Test Sales History' with 2 subforms 'Sales History Totals subform' and 'Sales History subform', that are controlled by a combo [Combo31] in the header, all works beautifully.

What I am trying to get to work, is.... When coming from another Form I have [Combo31] updated with the Membership Number from the previous form, and that works great.

What isn't happening is.... I want the subforms to load/update/refresh when that is done. When I hit 'ENTER' The records are shown in the subforms, however I need that 'ENTER' action to happen automaticly.

Here is the code I have for bringing in the Membership Number to the control ComboBox, the SearchforRecord in on the AfterUpdate and KeyPress events on the ComboBox

Private Sub Form_Current()
If CurrentProject.AllForms("NewViewEditMembership").I sLoaded Then


[Combo31] = Forms![NewViewEditMembership]![Membership Number]
***Guessing I need a requery/reload subforms action thing in here****
End If
End Sub

[rpeare]

If your first form is handling new data you will likely need to use

Me.REFRESH

BEFORE you do the second step which is to REQUERY and combo boxes, subforms, or forms based on queries

to requery a subform or combo box you would simply do something like:

on the active form me.<objectname>.requery

on another form forms!<formname>!<objectname>.requery