使用两个字段的数据更新组合框 [英] Updating combo box with data for two fields

问题描述

我希望使用带有2个详细信息的组合框来更新银行表：银行名称和排序代码。


我目前有一个连接的组合框，但我能够使用诸如分隔符之类的分隔符在更新时添加诸如BankName：BankSortCode之类的新信息。 ：识别2个独立的身份，并将此信息写回银行表？


任何有关此问题的帮助将不胜感激。


非常感谢


Tim

I am looking to update a bank table using a combo box with 2 details: Bank Name and Sort Code.

I currently have a concatenated combo box, but am I able to add new information such as BankName : BankSortCode on update with a separator such as " : " to identify the 2 separate identities, and write this information back to the Bank table?

Any help on this would be greatly appreciated.

Many thanks

Tim

推荐答案

Tim，


你可以参考使用cbMyComboBox.Column（0）[第一个字段]，cbMyComboBox.Column（1）[第二个字段]等组合框中名为cbMyComboBox的多个字段

Tim,

You can refer to multiple fields within a combo box named cbMyComboBox using cbMyComboBox.Column(0) [first field], cbMyComboBox.Column(1) [second field], etc.

Hi Steve


多亏了这一点，但不是100％肯定如何实现这一点。目前，我只是想放一个分隔符，因为我不想在我的组合框中有两列，只有一个。


目前，我的代码是

Hi Steve

Thanks for this, but not 100% sure how to implement this. At present, I am just trying to put a separator in, as I do not want 2 columns in my combo box, just the one.

At present, my code is

展开 | 选择 | Wrap | 行号

Tim，我迷失在你想要完成的事情上。如果我能帮忙，我需要更大的图片。你的银行表是什么样的（其中的字段）以及你想让用户做什么？


Steve

Tim, I''m getting lost on what you are trying to accomplish. If I can help I''ll need a bigger picture. What does your Bank table look like (fields in it) and what are you trying to allow the user to do?

Steve

这篇关于使用两个字段的数据更新组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！