Hi Guys
I Have A DB With 2 Tables , 3 Forms As Follows
Vehicles
Defects
Defects Subform
The Defects Subform Is Embedded In The Vehicles Form And Displays 5 Fields As A Datasheet From The Defects Form
The Records In The Datasheet Are Filtered By Whatever Vehicle Record Is Selected.
Im Wanting To Double Click On The Defect ID In The Datasheet And For It To Open Up The Defects Form Showing The Relevant Defect Record.
Here Was My Last Attempt
I Have Also Tried
Any Help Would Be Great