Refresh RowSource of combobox based on field on form

Question

I need another pair of eyes to tell me what I am missing. I have a form based on a table. On that form there is a combobox with a SQL rowsource: SELECT [MPActorQ].[MovieID], [MPActorQ].[Title], [MPActorQ].[PeopleID] FROM MPActorQ WHERE [MPActorQ].[PeopleID]=[Forms]![ActorFullF]![PeopleID] ORDER BY [Title]; 

This works correctly by listing only movies associated with people on the MPActorQ. The issue is that it only lists the movies for the first peopleID opened. I would like to have it update the combobox list when the record (peopleID) is changed. Ive tried lots of variations of: 

Private Sub PeopleID_AfterUpdate()

    Me.FavMovie.Requery

End Sub

but if the next or previous record button(or even record changed from another combobox) is selected the combobox data doesnt update. Ive also tries a few combinations on the Change event of peopleID.

I also thought of trying to use VBA to create the rowsource but I am not very good at creating my own code. 

Can anyone provide any suggestions on how to get my combo box rowsource to update depending on the peopleID displayed on the form?

Answer 1

Hi,

try the Requery in On-Current Form event.

Ciao Mimmo

Answer 2

I tried that and it didnt work before, but I got it now. Thanks!