编码下拉框复制信息 [英] Coding Drop down box to copy information

问题描述

大家好，我试图为非盈利的退伍军人组织创建一个数据库。数据库将用于呼叫中心，在那里他们接收呼叫者信息和退伍军人信息。然而，有时候来电者是老将。我有一个下拉列表，其值为退伍军人;亲人。如果选择退伍军人，我试图将表格上的来电者部分的名称值复制到退伍军人信息部分。所有这一切都发生在一个表格上，然后当提交进入数据库。任何建议？我的编程背景非常有限，因此将其分解为barney风格。会非常感兴趣的。感谢您的帮助并保持良好的工作。

解决方案

我认为最简单的方法是在下拉框的AfterUpdate事件中进行编码。让我们假设下拉框名为combo1，您需要编写如下代码...

展开 | 选择 | 换行 | 行号

< blockquote>太棒了，非常感谢你的帮助。我明白了，我肯定很快就会回来提问。再次感谢周末愉快。


VR，

Mike

@msquared


抱歉，我回来了。那么如果在组合中选择了亲人，我可以使用什么命令让退伍军人的领域变空？谢谢：）

Hello every one, Im attempting to creat a database for a non profit veteran org. The data base is going to be used in a call center, where they take the callers information and the veterans information. However some times the caller is the veteran. I have a drop down list with values of "veteran;loved one" if veteran is selected i am trying to have the name values from the caller section on the form copied down to the veterans info section. All this is taking place on one form then when submited is entered into the database. any suggustions? i have very limited programming background so breaking it down "barney style" would be greatly appriciated. Thanks for the help and keep up the great work.

解决方案

I think the simplest method for you would be to code in the AfterUpdate event of the dropdown box. Lets assume the dropdown box is called combo1, you will need to code something like the following ...

Expand|Select|Wrap|Line Numbers

Awesome, thank you so much for your help. i got it figured out, I''m sure ill be back soon with more questions. Thanks again have a great weekend.

VR,
Mike

@msquared
sorry I am back. so what command could i use to leave the veteran fields empty if loved one is selected in the combo? thanks :)

这篇关于编码下拉框复制信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！