calculated field...

  • Thread starter Thread starter anthony
  • Start date Start date
Use the BeforeUpdate event of your *form* (not control) to check the value
is acceptable.
 
Thanks Allen! i'll try.

-----Original Message-----
Use the BeforeUpdate event of your *form* (not control) to check the value
is acceptable.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Use the BeforeUpdate event of your *form* (not control) to check the value
is acceptable.
Click to expand...


Alternatively, you can check the calculated value in the BeforeUpdate
Event of _all_ of the Controls that contribute to it. Allen's method
is usually best, since you know that the user (thinks he) has entered
all the necessary information, but there are situations when it is
useful to check (and correct, if necessary) incorrect entries sooner
than that. If you use the Control BeforeUpdate approach, you have to
deal with the possibility that the user hasn't got to one of the other
relevant Controls yet, so that you generally should not flag any of
them being Null as an error.

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top