如何使用组合框显示表单中的特定客户记录 [英] How can I use a combo box to display specific customer records from my form

问题描述

大多数网站仅提供仅显示一条记录的表单示例。我想显示在组合框中输入的客户的所有记录

Most of the web sites only provide examples of forms to display only one record. I want to display all records of the customer entered inside the combo box

推荐答案

这应该很简单。只需将 DefaultView 属性设置为Continuous Forms。

That should be simple enough. Simply set the DefaultView property to Continuous Forms.

如果我理解你的问题，你想使用组合框进行查找客户以及与该客户相关的所有记录。


在这种情况下，

创建一个连续表单类型为子表单的表单，以显示所有记录。然后将子表单放入组合框所在的表单中。通过客户名称字段链接它。这样，当您使用组合框查找任何客户时，所有具有相同客户名称的记录都将列在子表单中。

if I understand your question right, that you like to use the combo box to lookup a customer and all the records that is related to that customer.

in this case,

create a form with continuous form type as subform, to show all the records. then bring the subform into the form where combo box is. link it by the customer name field. this way, when you use combo box to lookup any customer, all the record with same customer name will listed in the subform.

这是一个可行的，非常受欢迎的解决方案，实际上。


然而，它比你需要的更复杂。绝对没有要求单独一个表格，因为单个表格可以很好地完成你的工作。


记住KISS原则。

That''s a workable, and very popular solution, in fact.

However, it''s more complicated than you need. There''s absolutely no requirement to involve a separate form as a single one does the job for you perfectly well.

Remember the KISS principle.

这篇关于如何使用组合框显示表单中的特定客户记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！