Access2003表单/查询 [英] Access2003 Form/Query

问题描述

我有一个表单，绑定到查询。

表单上没有任何查询字段，因为表单只适用于导航。


在form.event（OnCurrent）中我想使用（在VBA中）查询字段，但是.....我如何引用QueryFields？


Thx

Hi,

I have a form, bound to a query.
None of the queryfields are on the form as the form is only there for navigation.

In an form.event (OnCurrent) I want to use (in VBA) the queryfields, but ..... how do I reference to the QueryFields ?

Thx

推荐答案

您可以通过键入字段名称来引用字段。

You reference a field by typing the field name.

我有一个表单，绑定到查询。

表格中没有任何查询字段因为表单只用于导航。


在form.event（OnCurrent）中我想使用（在VBA中）查询字段，但.....我如何引用到查询字段？


Thx

Hi,

I have a form, bound to a query.
None of the queryfields are on the form as the form is only there for navigation.

In an form.event (OnCurrent) I want to use (in VBA) the queryfields, but ..... how do I reference to the QueryFields ?

Thx

将查询字段放在表单上，​​但如果你不这样做就把它们设置为不可见我希望用户看到它们。

Put the query fields on the form but set them to invisible if you don''t want the user to see them.

Put th e表单上的查询字段，但如果您不希望用户看到它们，则将它们设置为不可见。

Put the query fields on the form but set them to invisible if you don''t want the user to see them.

这就是我想要避免的。

我以为我可以使用那种方式！captionname.fieldname引用而不是Me！fieldname

That''s what I wanted to avoid.
I thought I would have been possible to use sort of Me!captionname.fieldname referencing instead of Me!fieldname

这篇关于Access2003表单/查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！