获取一个组合框来存储多个值 [英] getting a combo box to store multiple values

问题描述

我正在设置一个数据库，并希望表单上有一个组合框来存储两个值。例如，有一个ID和一个描述。我可以轻松地获取组合框以显示ID和描述。但是组合框只绑定到一个字段，在这种情况下，ID。


我希望表单存储ID，然后在一个字段中显示描述ID旁边的字段。


非常感谢您的帮助，谢谢！


Todd

解决方案

我不确定你在问Todd。


您的解释似乎与我认为您要问的任何内容相矛盾：S

很抱歉！


我已经建立了一个表格，需要存储酒店ID，酒店和其他客户信息。酒店ID和酒店存放在一个单独的表中。当组合框打开时，酒店ID和酒店出现在下拉菜单中。但是b / c组合框是建立在酒店ID控制的字段上，只有酒店ID被转移到表格。酒店领域仍然空白。我打算构建一个宏并创建一个更新查询（我是一个GUI人员）来更新酒店字段，但我更愿意建立一个基于酒店ID的表达式，可以更新酒店。希望更有意义。


谢谢


todd

使用''列''具有组合框值的参数。

展开 | 选择 | Wrap | 行号

Hi,

I am setting up a database and would like a combo box on a form to store two values. for example, there''s a ID and a Description. I can easily get the combo box to show both the ID and the Description. however the combo box is tied in to one field only, in this case, the ID.

I''d like the form to store both the ID and then display the Description in a field next to the ID.

your assistance is much appreciated, thanks!

Todd

解决方案

I''m not sure what you''re asking Todd.

Your explanation seems to contradict anything I think you''re asking :S

sorry about that!

i''ve built a form that needs to store hotel ID, hotel with other client info. the hotel id and hotel are stored in a seperate table. when the combo box is opened, hotel id and hotel appear in the pull down. however b/c the combo box is built on a field controled by hotel ID, only the hotel ID is transferred to the form. the hotel field remains blank. i was going to build a macro and create an update query (im a GUI person) to update the hotel field but i''d prefer to build an expression that based on the hotel ID, can update the Hotel. hope that makes a little more sense.

thanks

todd

Use the ''column'' parameter with the combobox value.

Expand|Select|Wrap|Line Numbers

这篇关于获取一个组合框来存储多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！