Data Entry, Go to Last Edited Record

  • Thread starter Thread starter email.csmith
  • Start date Start date
E

email.csmith

I want a form to open on the last record that was edited. What would be
the appropriate code for this?

Thanks,
Chris
 
If you got a field that indicate which record was last to be entered, like a
date or AutoNumber, then sort the form RecordSource by this field Descending

Select * From TableName Order By FieldName Desc
 
I have no such field. I have a database with values for all but one
field on every record. (e.g., I am only missing ZIP codes in a contact
database). The data entry is occuring on this empty field only.

Any ideas?

Thanks,
Chris
 
Back
Top