我只想说rs应该声明为DAO.Recordset，否则它是不明确的。另外，rs（6）& rs（7）在你的未注释代码中完全没有意义。


对我有限的理解似乎唯一可疑的是你设置rs（6），但检查rs（7）。你也设置为-1但检查> 0。

I would say only that rs should be declared as DAO.Recordset, as otherwise it is ambiguous. Also, rs(6) & rs(7) are entirely meaningless in your uncommented code.

The only things that appear questionable to my limited understanding is that you set rs(6), but check rs(7). Also you set to -1 but check for > 0.

谢谢


这是更新后的代码：

Thanks

Here is the updated code:

@ matt753





你在哪里关门报告是为了让它再次重新打开以捕获循环中的下一个值？您打开报告以显示单个记录或通过标准，它肯定会显示一系列记录。你不应该打开一次报告吗？

@matt753
Hi,

Where are you closing the report in order for it to re-open again to catch the next value in the loop? You open a report to show either a single record or pass criteria to it show a sequence of records surely. Should you not be opening a report once?