I have a main form (customer) which has a sub form (PetSubform). A customer can have one or more pets and the PetId, pet name and breed is shown in the subform.

I would like to double click on a row in the subform and open a form which shows all the fields related to that pet.

I can double click and get a form to open, but i need the form to open and display the right info based on the PetID.

Is there a way to select the PetId in just the selected row in the sub report and then open the form based on the petid in the selected sub report row.

I suggest that you use a command button to activate the form. When you draw a command button on the PETSubform, follow the wizard to:

1. Open the pet form
2. Select the value you want
3. Link the fields together

Once this is done, you can see the code behind the button, on the CLICK Event.

I would suggest that rather than using a DATASHEET view, use a CONTINOUS FORM VIEW, and have a button appear next to each record.
Arrange the fields to that it looks like a datasheet.

This will get you started in the right direction.

Let me know how you do.

Richard