如何根据另一个组合框选择过滤组合框选择列表 [英] How can i filter a combobox selection list based on another combobox selection

问题描述

我确定这个问题可能已经死了，但是我找不到我可以上班的答案.基本上，我想拥有两个组合框控件.例如，一个框会选择一种装甲类型.下一个框将仅显示已选择装甲类型的那些单位类型.我对SQl完全不屑一顾，并且对VBA的使用非常有限，但是由于我对VBA的了解更好，所以我希望在VBA中做出回应. 在这件事上的任何帮助将是巨大的.请，谢谢你

I'm sure this question may have been asked to death, but I cant find any answer that i can get to work. Basically I would like to have two combobox controls. One box selects an armor type for example. The next box would show only those unit types that have the armor type selected. I'm complete crap when it comes to SQl and very limited with my VBA, but would prefer a response in VBA since I understand it better. Any help in this matter would be great. please and thank you

推荐答案

这是一个常见问题，搜索级联组合框"将返回许多答案，例如，MS知识库具有是否有一种简单的方法在该Access数据库模式中填充下拉列表?

This is a common question, and a search for "cascading combobox" will return a number of answers, for example, MS Knowledge base has How to synchronize two combo boxes on a form in Access 2002 or in Access 2003 and one from Stackoverflow : Is there a simple way of populating dropdown in this Access Database schema?

这篇关于如何根据另一个组合框选择过滤组合框选择列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！