Open form to show last (newest) record

[Guest]

My job records have a unique Ref that is dished out by DMax whenever a new
one is created. This works fine, and we can use a combo to find the
particular record that we want, by Ref.
However, whenever we open a job form it defaults to the first record.
How can I make it go to the last (newest) record i.e. the highest Ref,
instead?
Many thanks
CW

 

[Peter Hibbs]

CW

In the form's Form_Load event enter the following code.

DoCmd.GoToRecord , , acLast

This assumes that the records are sorted on the unique Ref field.

HTH

Peter Hibbs.

 

[Guest]

Thanks Peter, that does the job nicely!

CW

In the form's Form_Load event enter the following code.

DoCmd.GoToRecord , , acLast

This assumes that the records are sorted on the unique Ref field.

HTH

Peter Hibbs.