NatAccessNewbie
New member
- Local time
- Today, 20:09
- Joined
- Jan 25, 2022
- Messages
- 13
Hello
I want to be able to open a customers details by double clicking on their CustomerID from my Ongoing Orders Subform.
I've tried the code below which opens up the correct form but doesn't open to the relating customer that I clicked on. How do I define which customer's record needs to be displayed? TIA
Private Sub CustomerID_DblClick(Cancel As Integer)
DoCmd.OpenForm "CustomerDetailsF"
End Sub
I want to be able to open a customers details by double clicking on their CustomerID from my Ongoing Orders Subform.
I've tried the code below which opens up the correct form but doesn't open to the relating customer that I clicked on. How do I define which customer's record needs to be displayed? TIA
Private Sub CustomerID_DblClick(Cancel As Integer)
DoCmd.OpenForm "CustomerDetailsF"
End Sub