如何在不使用Openrecordset()的情况下引用表单中的记录集?

时间:2022-02-02 16:54:44

Is there a way to reference the recordset of a form without using Openrecordset()? My form has different records depending on different conditions, so it gets a little messy to do it that way. Is there anything similar to Me.Form.Recordset (which doesn't work, btw) that I can use? Thanks!

有没有办法在不使用Openrecordset()的情况下引用表单的记录集?我的表单根据不同的条件有不同的记录,所以这样做会有点麻烦。有什么类似于我可以使用的Me.Form.Recordset(这不起作用,顺便说一句)?谢谢!

1 个解决方案

#1


I'm not sure if RecordsetClone would work since I think it is read only.

我不确定RecordsetClone是否会起作用,因为我认为它是只读的。

This is the type of comments I never learn to understand. Why don't you just try? It will take you less time than sitting wondering.

这是我从未学过的评论类型。你为什么不试试?这会让你花费的时间少于坐着的想法。

So follow Hans. The recordset will be updatable at the same level as the form.

跟着汉斯。记录集可以在与表单相同的级别更新。

#1


I'm not sure if RecordsetClone would work since I think it is read only.

我不确定RecordsetClone是否会起作用,因为我认为它是只读的。

This is the type of comments I never learn to understand. Why don't you just try? It will take you less time than sitting wondering.

这是我从未学过的评论类型。你为什么不试试?这会让你花费的时间少于坐着的想法。

So follow Hans. The recordset will be updatable at the same level as the form.

跟着汉斯。记录集可以在与表单相同的级别更新。