Previous Previous Record

[COII]

Dear all,

I have a problem. I design a form and there is two fields called "Date" & "FirstReminder". When I input the date in "Date" field, I want "FirstReminder" will be filled previous record automatically. Just like that:

In first record,
Date : 02-Jun-02
FirstReminder: Blank

In second record,
Date: 02-Jul-02
FirstReminder: 02-Jun-02 (Automatically)


Can anyone help me?


Manda

 

[PMrider]

Put this in your control source of your [FirstReminder] textbox


=DMax(&quot;Date&quot;,&quot;DateTable&quot;,&quot;[Date] < [txtDate] AND[KeyFieldID] = [txtKeyfieldID] &quot

On form rename [ID] textbox as [txtID], but leave the control source the same
rename [Date] as [txtDate] but leave the control source the same


Hope this helps

Alan