使用复选框选择值 [英] Using Check Box to select a value

问题描述

嗨


我正在尝试使用复选框来选择值。当我点击一个复选框时，它应该从我的tblSysRating中选择RatingID。


复选框位于我的子表单上，RatingID文本框位于我的主表单上。

Hi

I am trying to use check boxes to select values. When I click on a check box it should select RatingID from my tblSysRating.

The check boxes are on my subform and the RatingID text box is on my main form.

推荐答案

嗨


我试图使用复选框来选择值。当我点击一个复选框时，它应该从我的tblSysRating中选择RatingID。


复选框位于我的子表单上，RatingID文本框位于我的主表单上。

Hi

I am trying to use check boxes to select values. When I click on a check box it should select RatingID from my tblSysRating.

The check boxes are on my subform and the RatingID text box is on my main form.

假设您的复选框位于选项组中，您可以在选项组上使用SELECT CASE语句。

假设：


选项组名称= frmOption1

Assuming your checkboxes are in an option group you can use a SELECT CASE statement on the option group.

Assumptions:

Option Group Name = frmOption1

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

嗨


感谢您的回复。


我的复选框不在选项组中，主要是因为我需要选择更多超过一个值。我的子表单上有36个复选框（6行，6列向下）


复选框表示评级值（关键任务，业务关键，不太关键）。例如。勾选1复选框表示任务关键，2个复选框表示业务严重，文本框的返回值RatingID应该是根据勾选框的最高值，在这种情况下，它将是关键任务。


有没有办法做到这一点，因为最高评级需要根据所选的复选框反映出来？


非常感谢任何帮助。

Hi

Thanks for the reply.

My check boxes are not in a option group mainly for the reason that I need to select more than one value. I have 36 check boxes on my subform (6 rows across, 6 columns down)

The check boxes indicate rating values (Mission Critical, Business Critical, Less Critical). Eg. 1 check box is ticked to indicate Mission Critical and 2 check boxes indicate Business Critical, the return value to the text box RatingID should be the highest value according to ticked boxes, in this case it would be Mission Critical.

Is there a way to do this as the highest rating will need to be reflected accordint to the check boxes selected?

Would appreciate any help with this.

嗨


感谢您的回复。


我的复选框不在选项组中，主要是因为我需要选择多个值。我的子表单上有36个复选框（6行，6列向下）


复选框表示评级值（关键任务，业务关键，不太关键）。例如。勾选1复选框表示任务关键，2个复选框表示业务严重，文本框的返回值RatingID应该是根据勾选框的最高值，在这种情况下，它将是关键任务。


有没有办法做到这一点，因为最高评级需要根据所选的复选框反映出来？


非常感谢任何帮助。

Hi

Thanks for the reply.

My check boxes are not in a option group mainly for the reason that I need to select more than one value. I have 36 check boxes on my subform (6 rows across, 6 columns down)

The check boxes indicate rating values (Mission Critical, Business Critical, Less Critical). Eg. 1 check box is ticked to indicate Mission Critical and 2 check boxes indicate Business Critical, the return value to the text box RatingID should be the highest value according to ticked boxes, in this case it would be Mission Critical.

Is there a way to do this as the highest rating will need to be reflected accordint to the check boxes selected?

Would appreciate any help with this.

或许如果你解释了更多关于我认为是某种查找表的RatingID。

Perhaps if you explained more about the RatingID which I assume is a lookup table of some kind.

这篇关于使用复选框选择值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！