在另一个中查询一个组合框 [英] Querying One Combo Box in Another

问题描述

嗨


我希望有人可以帮助我，我有一个带有两个组合框的表单....第一个组合框通过一个表从表中获取它的值组合框属性中的SQL查询。第二个组合框应该通过其属性中的SQL查询获取其值，但它取决于第一个组合框的结果...


ie。第一个combox包含已收到文档的所有人的姓名。 （此组合框非常有效）


第二个组合框仅显示第一个组合框中的人收到文档的日期。当您第一次选择名称时，这些值会正确显示，但是当您更改第一个组合框时，第二个组合框不会更新列表...另外，当您在第二个组合框中选择日期时，我收到错误您输入的值对此字段无效。您可能在数字字段？中输入了文本。这个我不明白，因为我没有在组合框中规定任何格式。


任何帮助将不胜感激。


谢谢

AK

Hi

I am hoping someone can help me, I have a form with two combo boxes in it.... The first combo box gets its values from a table via an SQL query in the combo box properties. The second combo box is supposed to get its values also via an SQL query in its properties but it is depending on the result of the first combo box...

ie. First combox has the names of all of the people who have received a document. (This combo box works perfectly well)

The second combo box is to show only the dates the person from the first combo box has received a document. These values come through correctly when you first select a name, but when you change the first combo box, the second one does not update the list... Also when you select the date in the second combo box I receive the error "The Value you have entered isn''t valid for this field. You may have entered a text in a numeric field"?. This I do not understand as I have not stipulated any formatting in the combo box.

Any assistance will be greatly appreciated.

Thank you
AK

推荐答案

嗨


我希望有人可以帮助我，我有一个带有两个组合框的表单....第一个组合框通过组合框属性中的SQL查询从表中获取其值。第二个组合框应该通过其属性中的SQL查询获取其值，但它取决于第一个组合框的结果...


ie。第一个combox包含已收到文档的所有人的姓名。 （此组合框非常有效）


第二个组合框仅显示第一个组合框中的人收到文档的日期。当您第一次选择名称时，这些值会正确显示，但是当您更改第一个组合框时，第二个组合框不会更新列表...另外，当您在第二个组合框中选择日期时，我收到错误您输入的值对此字段无效。您可能在数字字段？中输入了文本。这个我不明白，因为我没有在组合框中规定任何格式。


任何帮助将不胜感激。


谢谢

AK

Hi

I am hoping someone can help me, I have a form with two combo boxes in it.... The first combo box gets its values from a table via an SQL query in the combo box properties. The second combo box is supposed to get its values also via an SQL query in its properties but it is depending on the result of the first combo box...

ie. First combox has the names of all of the people who have received a document. (This combo box works perfectly well)

The second combo box is to show only the dates the person from the first combo box has received a document. These values come through correctly when you first select a name, but when you change the first combo box, the second one does not update the list... Also when you select the date in the second combo box I receive the error "The Value you have entered isn''t valid for this field. You may have entered a text in a numeric field"?. This I do not understand as I have not stipulated any formatting in the combo box.

Any assistance will be greatly appreciated.

Thank you
AK

有关主题的帮助，请参阅本教程：
级联组合框

非常感谢你的建议它给了我很多帮助。我已经提出了以下编码..

Hi,

Thank you so much for your advice it has helped me alot. I have come up with the following coding..

展开 | 选择 | Wrap | 行号

非常感谢你的建议，它给了我很多帮助。我已经提出了以下编码..

Hi,

Thank you so much for your advice it has helped me alot. I have come up with the following coding..

展开 | 选择 | Wrap | 行号

这篇关于在另一个中查询一个组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！