After update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TomK - 31 Oct 2007 14:39 GMT

I'm using an After Update event on a form to update one field with the
current date when a checkbox is checked, but the date doesn't display until I
scroll down the form. Is there some way to get the date to display right
after the box is checked (or at least once the next record is selected)?

Thanks,
Tom

Signature

Thanks,
Tom

Reply to this Message

Allen Browne - 31 Oct 2007 14:46 GMT

Sounds like you have a control that has a Name that is different from the
name of the date field.

In the AfterUpdate code, use the name of the control, not its field name.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I'm using an After Update event on a form to update one field with the
> current date when a checkbox is checked, but the date doesn't display
> until I
> scroll down the form. Is there some way to get the date to display right
> after the box is checked (or at least once the next record is selected)?

Reply to this Message

TomK - 31 Oct 2007 14:57 GMT

Thanks, Allen! That's what it was all right.

I appreciate it!

Tom

>Sounds like you have a control that has a Name that is different from the
>name of the date field.
[quoted text clipped - 6 lines]
>> scroll down the form. Is there some way to get the date to display right
>> after the box is checked (or at least once the next record is selected)?

Signature

Thanks,
Tom

Reply to this Message