Pointing a Sub-form to a particular record.
I'm in need of some assistance. I have a form displaying information on a particular record. On that form I have a combo box with details of members of staff this particular record refers to, the combo box is just selecting the name of the member of staff, this data is stored in an other table. I'm looking to display information on these members of staff on the same form, for instance job title ect... I attempted adding a sub form and trying to get it to open to the correct record, this failed the code I was using was a variation on some code I have used before.
DoCmd.OpenForm "formName", , , "NAME = " & Me.NAME
I couldn't convince it to accept
SubForm.SourceObject "formName", , , "NAME = " & Me.NAME
Any help would be greatly appreciated.
I don't need the data to be displayed in a sub form necessarily.