odbc sql server sql server 列名SelectedID无效

Question

问题描述：我其他在form里取得某行数据的ID 并将其保存到全局变量SelectedID 中，想在当前form里通过SelectedID选出本行数据并进行编辑，结果出现错误---列名SelectedID无效,那位知道什么原因如何解决，谢谢！RsBasicInfo1.RecordSource = "select * from scjbxx where ENTER_ID = SelectedID "
RsBasicInfo1.Refresh

Answer 1

RsBasicInfo1.RecordSource = "select * from scjbxx where ENTER_ID = " & SelectedID
RsBasicInfo1.Refresh

Answer 2

如果id是charRsBasicInfo1.RecordSource = "select * from scjbxx where ENTER_ID = '" & SelectedID & "' "
RsBasicInfo1.Refresh