[VBA]关于创建记录集

liushu-p

     jinming为变量，如何用到查询语句中，请指教！

     jinming = ComboBox2.Text

     cmd.CommandText = "select*from jinming"    '创建相应记录集
     Set cj = New ADODB.Recordset
     cj.CursorLocation = adUseClient
     cj.Open cmd, , adOpenStatic, adLockBatchOptimistic