Sorry Bill,
I could have added a bit more explanation regarding the code I sent you.
Basically, it looks at the form object to see what sort of control you want
to store a value in, and then chooses either the Date code or the other
alternative for all other control types.
I should have added
Please correct me if I'm wrong, and if there's a better place to ask, let
me know.
It is my understanding (experimentally verified) that the PriorToReset
event will fire when a new database row is produced for data entry. Inside
this event, I can use the passed in event object to get the Form and
Hi Bill,
I also encountered this problem. It turns out that you need to update the
Control's bound field. Below is a modified version of a Macro I use. To
update most Controls is fairly straightforward, but a Date Control is a bit
more complicated. As you can see, you pass the Control Name, the