"Chris" <ch*********@gmail.comwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...
>I have a query which I use to edit a table and a column that I type
the date that I edited the perticular record in the table. Is it
possable for the date to change automatically when I edit the record?
In a query? No. If you edited from a form (as you should) then it is easy to
use the BeforeUpdate event of the form to update the date.
You could use a datasheet view form that would look pretty much like your query.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com