Updating a Form

[Andy]

Hi,

New to Access... so please be kind.

Have designed a form which ithe user may wish to update the data in future
(name/address/tel info)
I would like to put a button on the page so the user can update the "edit
date" if they wish.
How can I do this so that hitting a button updates the "edit date" with the
current date?

Any help would be greatly appreciated

Andy

[Alan Webb]

Andy,
I am not sure I'd leave it up to the user to click on an explicit "Modified"
button anytime the data is changed. I'd probably put some code in the form
to set the value of a Modified column in my table to the current date and
time any time the AfterUpdate event fires. This way it's done without user
intervention.

"Andy" <an******@hotmail.com> wrote in message
news:11****************@nnrp-t71-02.news.clara.net...

Hi,

New to Access... so please be kind.

Have designed a form which ithe user may wish to update the data in future
(name/address/tel info)
I would like to put a button on the page so the user can update the "edit
date" if they wish.
How can I do this so that hitting a button updates the "edit date" with
the current date?

Any help would be greatly appreciated

Andy

[Andy]

Thanks for your reply. I understand what you mean about a using a new field
in my table. Still cant get the function to work though. Have created a
button on my form but still not sure of the process to write the current
date to the table. I am currently playing with the Command Button / On Click
/ Expression Builder..... am I barking up the wrong tree?? Would be grateful
for a bit more guidance !!

Thanks

Andy
"Alan Webb" <kn*****@hotmail.com> wrote in message
news:c-********************@comcast.com...

Andy,
I am not sure I'd leave it up to the user to click on an explicit
"Modified" button anytime the data is changed. I'd probably put some code
in the form to set the value of a Modified column in my table to the
current date and time any time the AfterUpdate event fires. This way it's
done without user intervention.

"Andy" <an******@hotmail.com> wrote in message
news:11****************@nnrp-t71-02.news.clara.net...

Hi,

New to Access... so please be kind.

Have designed a form which ithe user may wish to update the data in
future (name/address/tel info)
I would like to put a button on the page so the user can update the "edit
date" if they wish.
How can I do this so that hitting a button updates the "edit date" with
the current date?

Any help would be greatly appreciated

Andy

[Alan Webb]

Andy,
VBA is event based. Something happens that triggers an event which if there
is code associated with the event will get run. I'd get rid of the button
on the form. Instead, I'd open my form in Design View, Click on the
Properties button to view the form's properties, click on the Event tab and
look for the AfterUpdate event. Then I'd open the Event Procedure Builder
(Code Builder) and put my code in there. That way, it all happens without
the user doing anything.

"Andy" <an******@hotmail.com> wrote in message
news:11****************@nnrp-t71-02.news.clara.net...

Thanks for your reply. I understand what you mean about a using a new
field in my table. Still cant get the function to work though. Have
created a button on my form but still not sure of the process to write the
current date to the table. I am currently playing with the Command Button
/ On Click / Expression Builder..... am I barking up the wrong tree??
Would be grateful for a bit more guidance !!

Thanks

Andy