值未显示在Access窗体组合框中-ValuesnotshowinginAccessformcombobox

3  

I'd approach this slightly differently, set the combo box Row Sources to include both the id and text fields (you can hide the ID column if required by setting it's width to zero). Now add the ID fields to the employee query; you shouldn't need to join the other tables to the Employee table in this query, these fields are foreign keys and the combo boxes should show the text for you automatically. Set the form Record Source to this query, now set the combo box Control Source to the appropriate ID value from the form Record Source.

我的处理方式略有不同,将组合框Row Sources设置为包含id和text字段(如果需要,可以通过将ID宽度设置为零来隐藏ID列)。现在将ID字段添加到员工查询中;您不需要将其他表连接到此查询中的Employee表,这些字段是外键,组合框应自动为您显示文本。将表单Record Source设置为此查询,现在将组合框Control Source设置为Record Source窗体中的相应ID值。

If you let the wizard build a form for you based on the Employee table you will see this approach in action.

如果您让向导根据Employee表为您构建表单,您将看到此方法的实际应用。

0  

You have set the query as the recordsource for the form. A form only shows (and ties to) ONE record at a time.

您已将查询设置为表单的记录源。表单一次只显示(并绑定)一条记录。

Since you want the combo box to show all the values, you should set the RecordSource of the ComboBox to your query.

由于您希望组合框显示所有值,因此应将ComboBox的RecordSource设置为您的查询。

0  

ControlSource is the column name of the table where any user entry will be saved.

ControlSource是将保存任何用户条目的表的列名。

RowSource is where you type the name of the saved query or manual query typed directly into that field, which is used to provide a list of available drop down options for the combo box.

您可以在RowSource中键入直接键入该字段的已保存查询或手动查询的名称,该字段用于提供组合框的可用下拉选项列表。

RowSourceType should be set to Table/Query, which is based on aforementioned RowSource method.

RowSourceType应设置为Table / Query,它基于前面提到的RowSource方法。

Now to correct the problem of only displaying what you begin to type (i.e. "Allow AutoCorrect" in Property Sheet > Other) or already have saved for that record without other options appearing after clicking the drop down is the following:

现在,要解决仅显示您开始键入的内容(即“属性表”>“其他”中的“允许自动更正”)或已经为该记录保存的问题,而在单击下拉列表后没有显示其他选项的情况如下:

1. In Design View, click the combobox in question.

在“设计视图”中,单击相关的组合框。

2. Property Sheet > Format > Column Count = set the desired number of columns to display in drop down.

属性表>格式>列计数=设置要在下拉列表中显示的所需列数。

3. Property Sheet > Format > Column Widths = set the desired width of column in the drop down.

属性表>格式>列宽度=在下拉列表中设置所需的列宽。

4. Property Sheet > Format > List Width = set the desired width of the drop down itself.

属性表>格式>列表宽度=设置下拉本身的所需宽度。

5. Property Sheet > Data > Bound Column = set to the column of query table (i.e. 1 for ID and 2 for list options, if you only have two entries)

属性表>数据>绑定列=设置为查询表的列(例如,1表示ID,2表示列表选项,如果您只有两个条目)

Note: If your desired drop down options are column two and not column one (makes things easier btw) then do the following change from above:

注意:如果您需要的下拉选项是第二列而不是第一列(使事情变得更简单),请从上面进行以下更改:

2. Property Sheet > Format > Column Count = set the desired number of columns to two.

属性表>格式>列计数=将所需的列数设置为2。

3. Property Sheet > Format > Column Widths = add two entries 0",1" which means the ID field is not visible (0") and the options field is one-inch.

属性表>格式>列宽度=添加两个条目0“,1”表示ID字段不可见(0“),选项字段为1英寸。

The easiest way to sort this out in the beginning is to view the column header names to know what you are looking at in the meantime by doing the following: Property Sheet > Format > Column Heads = set to yes. At least you will know what is showing and whether or not you are on the right track.

在开头对此进行排序的最简单方法是通过执行以下操作来查看列标题名称以了解您正在查看的内容:属性表>格式>列标题=设置为是。至少你会知道什么是显示以及你是否在正确的轨道上。