如何在程序中绑定文本框,急!大侠帮忙

[dengjun1982]

strsql = " SELECT SubjectA.TiHao AS Expr1, SubjectA.TiMu AS Expr2, SubjectA.DaAn AS Expr3, "
strsql = strsql & " SubjectType.Flag AS Expr4, SubjectType.TiXin AS Expr5, "
strsql = strsql & " SubjectType.KeChen AS Expr6 "
strsql = strsql & " FROM SubjectA INNER JOIN "
strsql = strsql & " SubjectType ON SubjectA.Type = SubjectType.TiHao "
strsql = strsql & " WHERE (SubjectA.Type = " & strNode & ")"
Data1.RecordSource = strsql
Data1.Refresh
然后我想绑定SubjectA.TiHao和Text1.text绑定应如何写?

[dengjun1982]

一楼的大哥说的好像不对哦.大家帮我看看啊

• 打赏
• 举报

回复 赞

[射天狼]

Set Text1.DataSource = SubjectA.DataSource
Text1.DataField = "TiHao"

• 打赏
• 举报

回复 赞

[dengjun1982]

要是text2.datasource= subjectType.Flag
text2.datafield="flag"这样写的话会不会有问题？因为是两个不同的表呀！

• 打赏
• 举报

回复 赞

[vbman2003]

没明白你的意思

• 打赏
• 举报

回复 赞