大家好。这是对上一个问题的后续回答。我有一个表单与2个组合框,其中第二个取决于在第一个的值。我有代码显示下拉列表在第二个组合框,但我无法选择任何东西,但第一个条目。
表1:名称- Supply_Sources,字段- Source_ID(pk), SupplySourceName
表2:name - Warehouse_Locations, fields - WLocation_ID(pk), Location_Name
表3(连接):名称- SupplySource_WarehouseLocation,字段- Supply_Source_ID(pk), Location_In_ID(pk)
在我的表单'frmInventoryReceivedInput'我有cboSupplySource和cboWLocation。我用
填充cboSupplySource SELECT [Supply_Sources].[Source_ID], [Supply_Sources].[SupplySourceName]
FROM Supply_Sources;
cboWLocation的SQL为:
SELECT SupplySource_WarehouseLocation.Supply_Source_ID,
Warehouse_Locations.Location_Name FROM Warehouse_Locations
INNER JOIN (Supply_Sources INNER JOIN SupplySource_WarehouseLocation
ON Supply_Sources.Source_ID = SupplySource_WarehouseLocation.Supply_Source_ID)
ON Warehouse_Locations.WLocation_ID = SupplySource_WarehouseLocation.Location_In_ID
WHERE ((( SupplySource_WarehouseLocation.Supply_Source_ID)=
[forms]![frmInventoryReceivedInput]![cboSupplySource]));
在cboWLocation下拉列表中有3个选项(基于cboSupplySource)。然而,我选择哪一个并不重要,它默认是第一个。我需要做些什么才能选择其他选项?
我重新创建了它,它工作正常,我所做的唯一不同的是创建一个查询与SQL:
SELECT
SupplySource_WarehouseLocation.Supply_Source_ID, Warehouse_Locations.Location_Name
FROM
Warehouse_Locations INNER JOIN
(Supply_Sources INNER JOIN
SupplySource_WarehouseLocation ON
Supply_Sources.Source_ID = SupplySource_WarehouseLocation.Supply_Source_ID) ON
Warehouse_Locations.WLocation_ID = SupplySource_WarehouseLocation.Location_In_ID
WHERE
(((SupplySource_WarehouseLocation.Supply_Source_ID)=
[forms]![frmInventoryReceivedInput]![cboSupplySource]));
所以我可以从UI中单独检查那部分
对于cboWLocation,我有column widths
0";1",rowSource
qry_cbo2和bound column
2。尝试将绑定列从1更改为2,看看是否有帮助。
贝丝