I want a field in my form for a client database that will help me keep
track of the last time a clients data was updated. The best I can do
so far is reflect the date the clients data was first entered, but the
date does not update after that. I'm not much good beyond wizards but
I have the form pretty much where I need it, beyond this. I appreciate
your trouble and time.

Steve

Steve:
One line of code is required.
In design view for your form, right click the black box in the upper
left of the form. Click properties on the drop down menu.
In the proprieties dialog click the event tab.
In the list goto "before update" and click on the "..." at the far
right.
This will bring up a list box with three choices; pick code.
You will be in strange place. Don't worry.

You need to know the name of the date field you want to update.
Let us pretend that it is: DateLastUpdated.
You type:
me.datelastupdated = now()
(Actually when you type "me." , you will get a drop down with all
possible things that can go after the period. The name of your field
will be in the list)
you are done.
Close the Basic editor. (Just the plain old X box at the top right).
Then save the form.

That's it. It takes a lot longer to write this out than to do it.

Good Luck

Ira Solomon





On Sun, 11 Jan 2004 23:22:46 GMT, Ibizar <engsteve11 (AT) notmail (DOT) com>
wrote:

Thank you I appreciate your expertise and kindness.


Steve Bennett
www.karmastorm.com


On Sun, 11 Jan 2004 21:52:38 -0500, Ira Solomon
<isolomon (AT) solomonltd (DOT) com> wrote: