Default Date Value

Z

zyus

I hv this 2 fields in same table..

[chqdt] and [bankindt]

In normal circumstances [bankindt] date will follow [chqdt] but user can
change [bankindt] if neccessary.

How to default [bankindt] = [chqdt] for new record created thru form.

TQ
 
W

Wolfgang Kais

Hello "zyus".

zyus said:
I hv this 2 fields in same table..

[chqdt] and [bankindt]

In normal circumstances [bankindt] date will follow [chqdt] but
user can change [bankindt] if neccessary.
How to default [bankindt] = [chqdt] for new record created thru form.
Click to expand...

A default value is applied only when creating a new record. In your
case, you are already editing the new record, so you will have to
write an event procedure for the AfterUpdate event of the chqdt control
that does something like
Me.bankindt = Me.chqdt
 
Top