命令按钮问题 [英] Command Button Problem

问题描述

嘿大家，

我有一个命令按钮的代码。该按钮应该打开一个查询，其标准为：Forms！[Form Name]！[Control Name]。查询的[列名]字段应与表单中的[控件名称]匹配。如果查询中不存在指定控件名称的记录，我想要一个消息框来显示说明。我的代码如下：

Hey Everybody,
I have code for a command button. The button is supposed to open a query with a general criteria of: Forms![Form Name]![Control Name]. The [Column Name] field of the query should match the [Control Name] in the Form. If a record does not exist in the query for the specified control name, I want a message box to display stating so. My code is below:

展开 | 选择 | Wrap | 行号

推荐答案

嘿所有人，

我有一个命令按钮的代码。该按钮应该打开一个查询，其标准为：Forms！[Form Name]！[Control Name]。查询的[列名]字段应与表单中的[控件名称]匹配。如果查询中不存在指定控件名称的记录，我想要一个消息框来显示说明。我的代码如下：

Hey Everybody,
I have code for a command button. The button is supposed to open a query with a general criteria of: Forms![Form Name]![Control Name]. The [Column Name] field of the query should match the [Control Name] in the Form. If a record does not exist in the query for the specified control name, I want a message box to display stating so. My code is below:

展开 | 选择 | Wrap | 行号

我'我在If语句中试过这个表达式：

I''ve tried this expression in the If statement:

展开 | 选择 | Wrap | 行号

请在至少24小时之前，不要* BUMP *你的主题。

我们的专家和成员自愿提供他们的时间，不值得那些可能从他们的努力中受益的人不耐烦。


主持人。


我会稍后回答这个问题但是，和所有其他专家一样，我不会感激你的不耐烦。从你那里收到了PM，我现在对你不太感兴趣。我下班回家时会看到这个。

Please do not *BUMP* your thread before at least 24 hours have passed.
Our experts and members offer their time voluntarily and do not deserve to be treated with impatience by those who may benefit from their efforts.

MODERATOR.

I will look to answer this later but, like all the other experts, I don''t appreciate your impatience. Having received a PM from you too, I''m not feeling too generous towards you at the moment. I''ll look at this when I get home from work.

这篇关于命令按钮问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！