当Combobox-field不为空时自动激活复选框 [英] Automatically activate checkbox when Combobox-field is not empty

问题描述

你好


又是我。我有另一个问题，我无法通过自己或谷歌解决，如果你能帮助我，我会很高兴。


我的数据库包含一个包含人员详细信息的表格。存在具有组合框的子表单，其由语言组成。并且主窗口上有一个复选框（是/否），名称为转换器。


我想要一个复选框Translator如果选择子表单中组合框的语言，则会自动激活，反之亦然。我还想要的是，表格的最终用户无法手动激活或取消激活复选框。


有谁能告诉我怎么做？


问候和谢谢!!


迈克

Hello

It is me again. I have another issue that I can not solve by myself or with google and would be happy if you could help me.

My database consists a form with details of persons. There is a subform with a combobox that consists "languages" and there is a checkbox on the mainform (yes/no) with the name "Translator".

I would like that the checkbox "Translator" is automatically activated if a language from the combobox in the subform is chosen and vice versa. What I would like in addition, is that the checkbox can not be activated or deactivated manually by the enduser of the form.

Can anybody tell me how I can do that?

Greetings and thanks!!

Mike

推荐答案

随着答案的数量我已经提供了，我可能还写了你的数据库


首先，如果你有一个语言组合框，你可以将这个人限制为只有一种语言，

其次，根据你想要的描述，如果选择一种语言，根据定义，这个人就是翻译，所以翻译复选框中没有任何意义。


第三，只允许使用一种语言，这应该是主表单中的组合框，那么子表单中的内容是什么？


您是否需要重新考虑？


Phil

With the number of answers I have provided, I might just as well have written your DB

Firstly if you have a Combo box for languages, you restrict the person to only 1 language,

Secondly, from your description of what you want, if a language is selected, by definition the person is a translator, so there is no point in the translator checkbox.

Thirdly, with only one language allowed, this should be a Combo box in your main form, so what is in your subform?

Do you need a rethink?

Phil

亲爱的朋友


非常感谢，是的，你提供了很多答案我非常感谢!!我希望我不会有更多的问题...


我有一个子表单，其中包含语言的组合框。对于每个人，可以选择多种语言。这些语言位于单独的页面中。在子表单中。在表单的主页上，我有一个语言的复选框，以便您在一秒钟内看到是否可以要求某人进行翻译。因此，复选框。


问候


迈克

Dear Phil

Thanks a lot, and yes, you have provided really a lot of answers for which I am very thankful!! I hope I won''t have many more questions...

I have a subform in which is a combobox with languages. For each person, more than one language can be chosen. The languages are in an individual "page" in a subform. On the main page of the form, I have the checkbox with the languages so that you see just in a second whether a person can be asked for translation or not. Therefore, the checkbox.

Greetings

Mike

OK迈克，那很清楚，但是你是说如果一个人有任何语言，那么他们可以翻译子表格中列出的所有语言，或者你是说他们擅长某些他们可以翻译的语言，并且在其他语言中的能力有限？在这种情况下，复选框应该在子窗体上。


如果是前者，我仍然看不到复选框实现的内容，因为子窗体上的条目更容易在一个chec框中看到一个刻度线。


Phil

OK Mike, that''s clear, but are you saying that if a person has any language then they can translate ALL the languages listed on the subform, or are you saying that they are good at some languages which they can translate, and have limited ability in other languages? In which case the checkbox should be on the subform.

If it is the former, I still can''t see what the check box achieves as an entry on a subform is far easier to see than a tick in a chec box.

Phil

这篇关于当Combobox-field不为空时自动激活复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！