Newbie

V

V&J

Hello all,

I have a problem. I created a database. I would like a photo to show on my
form of the property record I am viewing. I can not make this happen not
matter what I try. Also, I would like to have my datemodified field to
update to todays date when any field is updated. I am sure it is a SetValue
command but it doesn't work.

Please Help!!

Thank you in advance :)
JM
 
M

Michel Walsh

Hi,


To modify a field each time another one is change, use the BeforeUpdate event of the form, add a
line of code like:


Me.DateModified = Now( )


That's all. It change the value of the field just the moment before the record would be saved. We
did not do it in the AfterUpdate event or the form, that would have mark the record as to be saved
again... generating a "dirty" loop.



Hoping it may help,
Vanderghast, Access MVP
 
Top