Access 2003表单中的复选框问题 [英] Checkbox problem in an Access 2003 form

问题描述

我是新手，我假设经验丰富的答案很简单。我在表单上有一个复选框，表示作业是''2ndCoat''。当用户选中该框时，我希望另一个字段（''PriceofJob''字段）减少65％。任何帮助都非常感谢。

I am new to this, I''m assuming the answer is simple for the experienced. I have a checkbox on a form to indicate that a job is a ''2ndCoat''. When the user checks the box, I want another field( the ''PriceofJob'' field ) to be reduced by 65%. Any help greatly appreciated.

推荐答案

这可以做到，但是如果我们有更多关于您的表单上的控件的信息（特别是名称），将会更容易）。

This can be done, but to help it would be easier if we had more info as to which controls are on your form (Names particularly).

我希望这是你要求的...表格有以下名称/ conntrols。

DateOfCall

CallTakenBy

姓氏

地址

城市

州

邮编
HomePhone

WorkPhone

CellPhone

传真

EstimatorName

PriceOfJob

2ndCoat（复选框）

I hope this is what you are asking for...The form has the following names/conntrols.
DateOfCall
CallTakenBy
LastName
Address
City
State
Zip
HomePhone
WorkPhone
CellPhone
Fax
EstimatorName
PriceOfJob
2ndCoat (Checkbox)

我还不知道如何粘贴代码，所以我只是要发短信。


将此代码放入2ndCoat复选框的AfterUpdate事件中：

I don''t know how to paste code in yet, so I''m just gonna plain-text this.

Put this code into the AfterUpdate event of your 2ndCoat checkbox:

展开 | 选择 | Wrap | 行号

这篇关于Access 2003表单中的复选框问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！