组合框不起作用。当我从组合框中选择值时，不会从组合框中选择它 [英] Combo Box is not working . When I select value from Combo box , It is not selected from Combo box

问题描述

我有3个表1.客户  2. InvoiceHeader 3.发票明细4.产品主数据

I have 3 table 1. Customer  2. InvoiceHeader 3. Invoice Detail 4. Product Master

外键关系是 

Foreign key relation is 

Customer.CustomerID  - > InvoiceHeader.CustID

Customer.CustomerID  -> InvoiceHeader.CustID

Product.ProductID - > InvoiceDetail.ProductID

Product.ProductID -> InvoiceDetail.ProductID

InvoiceHeader.OrdderID - > InvoiceDetails.OrderID

InvoiceHeader.OrdderID -> InvoiceDetails.OrderID

但是当我在表单中创建用于选择客户的组合框时，"在我的网站上查找记录"在我的组合框'选项中选择的基于表单的值是 在表单中添加表格"发票明细"时不可见。

But When I create the combo box in a form for the selection of the customer , 'Find a record on my  a form based value selected in my combo box ' option is  not visible when I add the table Invoice Details in the form.

如果我只添加了 客户，InvoiceHeader   表格会显示该选项但是当我添加发票明细时，该选项将从那里消失。

If I had added only  the Customer , InvoiceHeader   table the option will show but when I add Invoice Details the option will disappear from there.

请您告诉我原因。我正在使用office365

Please can you let me know the reason. I am using office365

Pol

polachan

推荐答案

我不确定我理解你的问题。 

I'm not sure I understand your problem. 

你想用Combos做什么？您是否尝试搜索现有记录集中的记录？或者您是否尝试通过选择这些组合中的值来添加/编辑记录？

What are you trying to do with the Combos? Are you trying to SEARCH for records in an existing set of records? Or are you trying to add/edit records by selecting values in those combos?

如果您正在搜索记录，请确保您的组合不是绑定（即它们没有ControlSource ）。 

If you're Searching for records, be sure that your combos are not Bound (i.e. that they have no ControlSource). 

如果您正在编辑记录，那么当然您希望它们是绑定。

If you're Editing records, then of course you'd want them to be Bound.

这篇关于组合框不起作用。当我从组合框中选择值时，不会从组合框中选择它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！