表单上没有填充存储数据的组合框 [英] Combo boxes on form not populating with stored data

问题描述

我有一个包含三个组合框的表单：Area，Sub-Area和Factor。我已经设置了子区域组合框，仅列出属于所选区域的区域。我已经设置了因子组合框，仅列出属于所选子区域的那些因子。


例如，如果我选择区域1.0，则子区域组合框显示1.1,1.2和1.3作为选项。它没有显示2.1,3.1等。


如果我选择区域2.0，则子区域组合框仅显示2.1，而不是1.1,1.2,3.1等。


我想你明白了。


组合框工作正常，数据正确存储在表中。但是，当我返回并通过我的表单查看记录时，组合框是空的。当我点击空的组合框时，列表中突出显示了正确的值...当我第一次看到记录时，它只是没有显示。


任何想法如何让组合框正确填充存储的值？

Hi,

I have a form with three combo boxes: Area, Sub-Area, and Factor. I''ve set up the Sub-Area combo box to list only those areas that are part of the selected area. I''ve set up the Factor combo box to list only those factors that are part of the selected sub-area.

For example, if I select area 1.0, the Sub-Area combo box displays 1.1, 1.2, and 1.3 as options. It does not show 2.1, 3.1, etc.

If I select area 2.0, the Sub-Area combo box displays only 2.1, not 1.1, 1.2, 3.1, etc.

I think you get the idea.

The combo boxes are working properly and the data is being stored in the table correctly. However, when I go back and view the records through my form, the combo boxes are empty. When I click on the empty combo box, the correct value is highlighted in the list... it just wasn''t showing when I first look at the record.

Any ideas on how to have the combo boxes correctly populate with the stored values?

推荐答案

为了让一个给定的记录在你离开记录时保留其组合框的值然后返回时，组合框必须绑定到基础表中的字段。当您选择组合框并转到其属性表时，它是否有控制源下列出的任何内容？


欢迎脚趾字节 ！


Linq ; 0）>

In order for a given record to retain the value of its comboboxes when you leave the record and then return, the comboboxes have to be bound to fields in the underlying table. When you select a combobox and go to its Properties sheet, does it have anything listed under Control Source?

Welcome toes Bytes!

Linq ;0)>

是的，对不起我最初没说清楚。数据存储在表格中...控制源设置正确。


当我回到表格中查看记录时，该字段没有问题在我点击进入组合框之前不会填充。

Yes, sorry I didn''t make that clear originally. The data is being stored in the tables... the control sources are set up properly.

The issue that when I go back and look at records through the form, the field doesn''t populate until I click into the combo box.

二十个字符凹凸

这篇关于表单上没有填充存储数据的组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！