Populate subform from combo box (1 Viewer)

[statsman]

I retired a few years back and I have gotten away from Access I'm still using Access 07.
I am constructing a sports league database. I have a form which will allow the operator to correct any mistakes in the data entry.
It consists of a main form titled FrmTeamCorrect. In this form there is a combo box to select the team.
The subform presents the data to be corrected. It is opened using a query with [Forms]![FrmTeamCorrect]![Combo1] in the TeamName field.
The query works when I run it and enter the TeamName manuallu, but when the subform is added to the main form and a team is selected in the Combo box, nothing happens in the subform.
Unless you click on Design View and then back to Form View. Then the team data you selected in the combo box is displayed.
I believe that I'm just out of practice, but any assistance will be gratefully accepted.
:banghead:

 

[isladogs]

Try adding the line Me.Requery in the combo after update event

 

[theDBguy]

Hi. Just curious, what’s on the main form besides the combobox? Is the main form bound? If so, are the main and subform linked to each other?

 

[statsman]

The only thing on the main form is the combo box.
No links at this time, but that may change as I screw around with it.
The subform is linked to the query.

 

[statsman]

Try adding the line Me.Requery in the combo after update event

That did the trick. It now works perfectly.
Many thanks

 

[isladogs]

Excellent. Glad I could help