Updating a subform form another subform (1 Viewer)

[Zaeed]

Hey.

On a form, i have two subforms.

One displays a list of user id's (listSubform), the the other displays a username (nameSubform)..

What i'm trying to get to happen is when a id is clicked in listSubform, I want the corresponding name to be displayed in nameSubform..

This shouldn't be difficult, but I can't seem to get it to work.. Not enough coffee may be the issue..

Here's what i have so far..
This code is in the listSubform form

    Forms!frm_updateGroup!frm_updateGroup_userSubform.Form.RecordSource = "SELECT [qry_getName].[Name], [qry_getName].[UserId] FROM [qry_getName] WHERE [qry_getName].[UserId] = " & Me.frm_groupsSubform_Members.Value
    Forms!frm_updateGroup!frm_updateGroup_userSubform.Form.Requery
    Forms!frm_updateGroup!frm_updateGroup_userSubform.Form.Refresh

Cheers for your help

 

[Zaeed]

nevermind, turns out I had a typo in the sub name

 

[Zaeed]

Quick question..

If a subform has its recordsource changed, then is requeried.. which sub is called on the form? Is Load run again? or is it the AfterUpdate?