Finding record on Main Form from Subform

[djbls]

Hello,

I have tried everywhere for a solution to this Any help is much appreciated.

I have a main form with a subform. The subform shows related records using a match criteria. Each record that shows in the subform also has a unique ID. This unique ID is also shown on the main form record (although not used to link the main and sub forms).

I would like to be able to click on a command button on each of the records in the subform and goto the Main form record. I can't find any threads that deal with this though - sorry!

Hope it makes sense

DJ

 

[djbls]

Thanks very much to RexesOperator - I used his code (and tweaked). Works like a dream!