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

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.



"Bob" wrote:

>
>
> 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
>
>
>

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

"Wayne-I-M" <(E-Mail Removed)> wrote in message
news:48084C06-D1C5-4239-BA29-(E-Mail Removed)...
> 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.
>
>
>
> "Bob" wrote:
>
>>
>>
>> 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
>>
>>
>>