auto update

[Guest]

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in
column B always enters the date that the certain # was entered into column A.
or a good tutorial will help
im using access 2000 and the generel date/time format
thanks

 

[Jeff Boyce]

It sounds like you are working directly in a table. What you want to do is
not possible from an Access/Jet table (but could be done with triggers in,
say, SQL Server).

On the other hand, what you are asking to do is a "piece of cake" if you are
working in a form based on either the table or a query of it. In a form,
you have a rich Event environment. You can use the AfterUpdate event of the
control bound to the "column A" to test for a value of "15", and insert
Date() into column B's control on the form.