On Click of a Subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 25 May 2007 10:28 GMT

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

Reply to this Message

Wayne-I-M - 25 May 2007 11:00 GMT

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

Signature

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

Reply to this Message

Bob V - 25 May 2007 23:00 GMT

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

> Hi Bob
>
[quoted text clipped - 12 lines]
>> event to go to frmClientInfo,that has the same ClientID
>> (AutoNumber)................Thanks for any Help.....Bob

Reply to this Message