如何显示名称而不是值？ [英] How do I get a name to display instead of a value?
本文介绍了如何显示名称而不是值？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个我正在制作的数据库。我有1个数据表。
我正在制作一个限制这将限制基于组合框的记录。当我选择表列列表时，它具有所有名称。当我达到限制时，它会经过这里。
I have a database I am making. I have 1 table with data.
I am making a "limit" that will limit records based on a combobox. When I select the table column list it has all the names. When I hit limit it goes through here.
展开 | 选择 | Wrap | 行号
推荐答案
假设cmbLocalOffice已绑定对于基于表的表，查询或SQL语句，您很可能会读取绑定列的值。您要查找的实际值位于绑定之外的另一列中。在组合框选择中引用列值的语法是：
Assuming cmbLocalOffice is Bound to your Table, a Query, or an SQL Statement based on the Table, you are more than likely reading the Value of the ''Bound'' Column. The actual Value you are looking for resides in another Column other than the ''Bound'' one. The Syntax for referring to a Column Value within a Combo Box selection is:
展开 | 选择 | Wrap | 行号
如果你看到我的附件，我的cmblocaloffice是我的屏幕上的组合框与选择。在左边是我想根据我选择的内容限制的列表。在屏幕截图Help3.jpg上你看到它找到了正确的值1，但是为什么它改变了我的截图help4.jpg来说＃1而不是Albany，它仍然没有限制它？
在你的陈述中，是否需要这样编码？或表格属性？
if you see my attachments, my cmblocaloffice is a combo box on my screen with the selections. on the left is the list i want to limit based on what i select. On screenshot Help3.jpg you see that it is finding the value 1 which is right, but why does it change my screenshot help4.jpg to say a #1 instead of Albany, and it still does not limit it?
On your statement, does that need to be coded like that? Or a form property?
之后似乎有一些遗漏的代码建立GCriteria并填充本地办公室，请发布它。另外，发布组合框的行源。
There appears to be some missing Code after GCriteria is established and Local Office is populated, kindly Post it. Also, post the Row Source for the Combo Box.
这篇关于如何显示名称而不是值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
