需要帮助在表单中生成客户编号。 [英] Need help generating a customer number in a form.

问题描述

我已经设置了一个表单来包含客户信息。从那个表格，我有一个按钮显示订单将其链接到订单号表单。该订单号表单包含显示订单详细信息（数量，项目）的子表单。当我在客户信息表单上并单击显示订单时，它仅显示与该特定客户编号关联的订单。 （这很好。）但是当我想输入新订单时，我怎样才能让它自动填写客户编号？


我定义了所有关系。我是一个新用户，所以要温柔。 :-)


通过[根据网站规则删除的电子邮件地址]向我发送电子邮件，如果有帮助，我会向您发送屏幕截图。它们太大而无法附着。 （我所知道的是打印屏幕 - >粘贴在Paint中。）我想如果你看到我的屏幕截图，它会清除任何混乱。

解决方案

我认为SubForms处理得这么好。


否则，对于单独的表单，我使用的技术是为表单中的控件设置 .Default 属性。 / blockquote>

你能告诉我如何安排Default属性吗？你可以使用MainFormName，MainFormField（我要复制FROM），SubFormName，SubFormField（我要复制的内容）。

谢谢。

As表格上没有字段（有控件 - 理解差异是一个非常好的主意，因为它可以节省大量的混淆）我将使用 MainFormControl & SubFormControl 分别。


但是，我需要你解释一下我们在这里处理的形式。我以为你输入的订单开始了（这需要设置MainFormControl.Default）。我希望在 MainForm 中设置订单号后，无需在 SubForm 中设置默认值。链接应该为您排序。


我还需要知道当订单号值输入到 MainForm 时是否已经打开原始表单，或者单击命令按钮显示订单时是否从头开始打开MainForm。

I have set up a form to contain customer info. From that form, I have a button "Show Order" that links it to a Order Number form. That order number form contains a subform showing order details (qty, items). When I am on the customer info form and click SHOW ORDER it only shows me the orders associated with that particular customer number. (That is good.) But when I want to enter a new order, how can I get it to automatically fill in the customer number?

I have all my relationships defined. And I am a new user, so be gentle. :-)

Email me at [Email address removed per site rules] and I will send you screen shots if it helps. They were too large to attach. (All I know is print screen-->paste in Paint.) I think if you saw my screen shots it would clear up any confusion.

解决方案

I think SubForms handle this well enough.

Otherwise, for separate forms, a technique I use is to set the .Default property for the control within the form.

Can you tell me how to arrange the Default property? You can just use MainFormName, MainFormField (what I want to copy FROM), SubFormName, SubFormField (what I want to copy to).
Thanks.

As there are no fields on a form (there are controls - it''s a really good idea to understand the difference as it saves tons of confusion) I will use MainFormControl & SubFormControl respectively.

However, I need you to explain which form we are dealing with here. I thought you were entering an order to start with (that would require the MainFormControl.Default to be set). I expect when the order number has been set up in MainForm it will not be necessary to set the default in SubForm. The linking should sort that out for you.

I also need to know if MainForm is guaranteed to be open already when the order number value is entered into the original form, or whether MainForm is opened from scratch whenever the Command Button Show Order is clicked.

这篇关于需要帮助在表单中生成客户编号。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！