另一个多组合框问题 [英] Another Multiple Combo box Question

问题描述

大家好，


我将表单设置为带有2个组合框（Combo0& Combo4）和2个文本框（text8& text10）的对话框。 />

表单的记录源设置为名为Customers的表。


Combo0的行源设置为包含客户中的客户名称字段


Combo4仅列出从combo0中挑选出的客户城市。


Text10的控制源是客户的州域

Text8的控制源是客户的唯一ID字段。


当您在combo0中选择客户名称然后选择城市时在combo4 text10& text8变为可见，并显示该位置的相关状态和唯一ID。


我的问题是，如果同一城市中有多个客户，我的代码只返回状态（Text10 ）和表格中第一场比赛的解析ID（Text8）。


这里是combo0 AfterUpdate的代码：

Hi Everyone,

I have a form set as a dialog box with 2 Combo boxes (Combo0 & Combo4) and 2 text boxes (text8 & text10).

The form''s record source is set to a table named Customers.

Combo0''s row source is set to a query conatining the Customer Name Field in Customers

Combo4 lists only the citys of whaterver customer is picked from combo0.

Text10''s control source is the state field in customers
Text8''s control source is a unique ID field in customers.

When you choose a customer name in combo0 and then a city in combo4 text10 & text8 become visible and dsplay the related state and unique ID for that location.

My problem is that if there is more than one customer in the same city my code only returns the state(Text10) and unquie ID(Text8) for the first match that it comes to in the table.

Here''s the code of combo0 AfterUpdate:

展开 | 选择 | < span class =codeLinkonclick =WordWrap（this）;> Wrap | 行号

推荐答案

查看本教程。

卡斯卡ding combo / list boxes

是的，我看过这个，我的组合框工作正常。从我遇到问题的组合框中挑选后，我想在文本框中找到结果。


谢谢！

Yea, I''ve looked at this and my Combo boxes work fine. it''s the results I want in the text boxes after picking from the combo boxes that I''m having a problem with.

Thanks!

是的，我看过这个，我的组合框工作正常。从我遇到问题的组合框中挑选后，我想在文本框中找到结果。


谢谢！

Yea, I''ve looked at this and my Combo boxes work fine. it''s the results I want in the text boxes after picking from the combo boxes that I''m having a problem with.

Thanks!

更新后的combo0不遵循本教程的规则。再看看它。

The combo0 After Update does not follow the rules of this tutorial. Have another look at it.

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