根据单独表中的字段在表单的绑定字段上设置值

问题描述

使用附加数据库。打开表格DH添加订单含税。我想自动填充绑定控件INVNUM。它的来源是表INVOICE中的字段INVNUM。

我希望使用SetValue宏，使用DMAX表达式来设置值。

问题是INVOICE包含一些超过900,000的非常旧的INVNUM。我想拿起当前INVNUM在46822结束的地方，所以我的下一个INVNUM将是46823.

我想我需要在我的表达式中结合Where语句，但我不知道该怎么做。

本质上它会说，在表格上设置INVNUM的值，其值大于表INVOICE中最大的INVNUM，低于900,000。

Any建议？

谢谢

解决方案

Using attached database. Open Form "DH ADD ORDERS w/Tax". I would like to autopopulate the bound control "INVNUM". It''s source would be the field INVNUM in the table INVOICE.
I was hoping to use a SetValue Macro, using a DMAX expression to set the value.
Problem is that INVOICE contains some very old INVNUM above 900,000. I want to pick up where the current INVNUM end at 46822, so my next INVNUM would be 46823.
I think I need to couple a Where statement in my expression, but am not sure how to do it.
In essence it would say, "Set Value of INVNUM on the form at a value one greater than the greatest INVNUM in the Table INVOICE that is below 900,000.
Any suggestions?
Thanks

解决方案

这篇关于根据单独表中的字段在表单的绑定字段上设置值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！