Obtaining current records in form

[jdwm2310]

Hi,

I would like to view the most current records in my form. I have a primary form call Employees, this forms has several command buttons which opens other related forms in preview mode such as SERP Plan, Enrollment Plan, Savings Plan, etc. All these related forms have filters to open based on the selected employee, however some employees update or change their information. I want to see the lastest change without having to see all of that person's record.

Any suggestions would be appreciated

Thanks

 

[ToeShot]

This may not be the best way but it is simple. Put a ChangeDate Field in each of the tables. Then place it on each form and keep it hidden. When a person edits a record check to see if the edit was saved then set the hidden date field to today (day of edit). Sort your tables by the ChangeDate Field. For example

Private Sub Form_Dirty()

If (Me.Dirty) Then
ChangeDate = Now()
End If

HTH

 

[jdwm2310]

ToeShot,

I created the field name ChangeDate on my tables and I insert the field in the forms. I made the field invisible. I sorted my tables by the ChangeDate field. but where do enter the code you provided??????

Thanks