making Date change 1

[jtfrier]

I have a list of finders with each vinder having a date modifyed or date a reapproved when i change this date on my form i want the date to change for all the venders so if i edit the date for vendoer 1 I want the dates for venders 2-# of venders to change too. one approch that i though about takeing was to creat a diffrent table and have just the date enterd there and then just call that date on my report but was wondering if there is a beater way to do this though code. pleas help thanks.

 

[Remou]

It is probably better to store this date in a separate table if it is the same for all vendors. You can use DlookUp to get the date in queries and reports. For example you can set the Control Source of a textbox to:
=DlookUp("ApprovedDate","tblLookUps")

 

[jtfrier]

Thank you