Turning a textbox into a command button for subform datasheet entries

[apk19]

Got an interesting one.

I want to dress-up a textbox in a subform as a command button. The reason is that buttons are not allowed in datasheet view, which is by far the best way to display the data.

I've got the coding down pat:

Private Sub Text13_Click()

DoCmd.OpenForm "Applicants", , , "ClientID = '" & ClientID & "'"

End Sub

Tested and works fine. I even have it as a Hyperlink.



Only problem is that the field returns "#Name?" error. Is there anyway of making the text as "GoTo" for all entries instead? Perhaps some very basic coding?

[June7]

You mean you have textbox IsHyperlink property set to Yes?

Why would there be "#Name" error?

What field is this textbox bound to - ClientID?

Try: ="GoTo#" & [ClientID] & "#"

[apk19]

Hi June7,

You are correct in that the textbox "Is Hyperlink" property is set to Yes.

Stupid me...I set the Control Source to "GoTo".

[June7]

Actually, my suggestion to construct hyperlink string probably not useful. Just do:

="GoTo"