Problem with subform and command button

[ekta]

I created a subform and I want that when the user selects a record within a subform and clicks on the command button which is on the same form it should take the user to that particular record which he/she selected in the subform. I know how to connect the command button to the form but I want that it should open the record which the user selected in the subform, not the form.

Please help me with this.

Thanx
Ekta

 

[afloyd]

A clarification question - how are you displaying the record that the user selects from the subform? Is it on the parent form? This will determine how you filter your recordset.

 

[ekta]

It's on the parent form. I have a combo box on the parent form. When a user selects a value in the combo box all the records related to that value are displayed in the subform.