On Click of a Subform

[Bob]

I have a subform on another Form, The subform has a Textbox/Control Source
[ClientID] what would I need in the Textbox/Control Source [Name] On Click
event to go to frmClientInfo,that has the same ClientID
(AutoNumber)................Thanks for any Help.....Bob

 

[Wayne-I-M]

Hi Bob

Private Sub ClientID_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmClientInfo"
stLinkCriteria = "[CDClientID]=" & Me![CDClientID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

 

[Bob V]

Thanks Wayne , absolutely fantastic , I did drop the CD out of CDClientID
, is that OK?.....Regards Bob

Hi Bob

Private Sub ClientID_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmClientInfo"
stLinkCriteria = "[CDClientID]=" & Me![CDClientID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub


--
Wayne
Manchester, England.

I have a subform on another Form, The subform has a Textbox/Control
Source
[ClientID] what would I need in the Textbox/Control Source [Name] On
Click
event to go to frmClientInfo,that has the same ClientID
(AutoNumber)................Thanks for any Help.....Bob