BeforeUpdate to Validate表单 [英] BeforeUpdate to Validate form

问题描述

我想使用BeforeUpdate事件验证我的表单。


但是现在我用beforeupdate调用我的代码它不会让我去

到下一个或以前的记录。


我应该放什么代码o允许我做这个？

解决方案

我试过投入


DoCmd.GoToRecord ,, acNewRec


如果所有支票都已完成


但是我的运行时错误是2105


说你不能去指定的记录

< SI ************ @ gmail.com>在消息中写道

news：11 ********************** @ f14g2000cwb.googlegr oups.com ...

我想使用BeforeUpdate事件来验证我的表单。

然而，现在我用一个beforeupdate调用我的代码它不会让我去下一个或以前的记录。

我应该输入什么代码o允许我这样做？

你的意思是什么？验证我的表格？


Keith。

我正在检查每个文本，以查看是否已填写。


一旦他们全部被填满，我创建另一个值（收据

号码），我存储在另一个未经验证的文本框中

。 />

所有代码都有效，除非我从BeforeUpdate调用它验证

创建新值但不会转到下一个表单/记录。而且它的价格非常高。

I want to validate my form using a BeforeUpdate event.

However now that i call my code with a beforeupdate it wont let me go
to next or previous records.

What code should i put in o allow me to do thi??

解决方案

Ive tried putting in

DoCmd.GoToRecord , , acNewRec

If all the checks are complete

But i get a runtime error of 2105

Saying you can not go to the sepecified record

<si************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I want to validate my form using a BeforeUpdate event.

However now that i call my code with a beforeupdate it wont let me go
to next or previous records.

What code should i put in o allow me to do thi??

What precisely do you mean by "validate my form"?

Keith.

I am checking each text filed in turn to see if it has been filled out.

Once they have all been filled i create another value (a receipt
number) which i store in another textbox which is not being validated
in this.

All my code works except when i call it from BeforeUpdate it validates
creates the new value but doesnt go to the next form/record. And its
getting pretty anoying.

这篇关于BeforeUpdate to Validate表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！