我有一个包含3个列表框的表单,我试图根据2个输入/文本框中给定的范围来查询这些列表框。我不确定如何让脚本查看文本框。
Me.lstDailytop.RowSource = " SELECT StockCode, SumOfQTY, Date from qrytpdailystck WHERE [Date] BETWEEN Me.txtStart.Value And Me.txtEnd.Value"
Me.lstMonthlytop.RowSource = " SELECT StockCode, SumOfQTY, Date from qrytpmonthstck WHERE [Date] BETWEEN Me.txtStart.Value AND Me.txtEnd.Value "
Me.lstYearlytop.RowSource = " SELECT StockCode, SumOfQTY, Date from qrytpyearstck WHERE [Date] BETWEEN Me.txtStart.Value AND Me.txtEnd.Value "
当我运行这个命令时,它会询问Me.txtStart.value
和Me.txtEnd.value
的值。我假设有一种方法可以让VBA知道它引用的是对象而不是变量。我想不通了。希望有人知道我做错了什么。
https://stackoverflow.com/questions/56263326
复制相似问题