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
Cheers for your help
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
Code:
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