How to populate a form from a subform 1

[Greyfleck]

I have a form displaying all details from one record in a table and a subform (datasheet) that contains all records from the same table but only displaying key information. I want the user to be able to click on a record on the subform and for the main form to then display all the associated data for just that one record.

Any suggestions greatfully received.

Jon

 

[Remou]

You can use the recordset clone of the main form to find the relevant ID and the bookmark property to show the record. The Click or DblClick events of the subform will probably suit.

 

[PHV]

I'd use the Current event procedure of the subform to call the FindFirst method of the mainform's RecordSet object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Greyfleck]

Thanks PHV - I always check out all responses so will try this one too to see what suits me best.