在打开的表单上设置值从弹出窗体中 [英] Setting a value on an open form From a pop up form
问题描述
我的数据库上有一个NewOrders表单。
如果我有一个新客户，我创建了一个弹出窗体，我填写了新的客户详细信息，包括CustomerID，然后我关闭此表单并返回NewOrders表单。我想要发生的是新客户然后在NewOrders表单的CustomerID字段中输入。此字段设置为组合框，在订单表设计中设置的查询中显示客户名称。我希望这是有道理的，也要提前感谢任何帮助
Martin
Hi,
I have a NewOrders form on my database.
If I have a new customer I have created a pop up form and I fill in the new customer details including CustomerID and then I close this form and return to the NewOrders form. What I would like to happen is the new customer be then entered in the CustomerID field on the NewOrders form. This field is set up as Combo Box displaying the Customer name in a query set up in the Order Table design. I hope this makes sense and also thanks in advance for any help
Martin
推荐答案
在你之后的弹出窗体中有客户ID你可以把像
In the pop up form after you have the customer ID you can put something like
首先我在已经离开的回复中道歉。我已经尝试过这个代码，当你回到主订单表（NewOrders）时，它就在下拉列表中，所以谢谢你。但是我希望自动将它放在字段中，这样你就不必滚动它了。
Hi, firstly I apologise in the late reply I have been away. I have tried this code and it works as far as when you go back into the main Order Form (NewOrders)it is in the drop down list,so thank you. But I was hoping to have it automatically put in the field so you do not have to scroll for it.
为此，你应该将ComboBox的值设置为新客户的值。 。这将为您选择列表中的值。
For that you should set the value of the ComboBox to the value of the new customer. That will select that value in the list for you.
这篇关于在打开的表单上设置值从弹出窗体中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
