I'm sure there is an easy way to do this I want to use a button to open a form and want the highest record no to be shown on that form.

To explain I have a form that uses tow fields from a table ID and name, when I close that form I want to open the full listing to allow input of additional details