I'm using Microsoft Access and I have a form bound to a table. The primary key of the table is ItemCode + PriceDate. I'd like to add a button to the form that jumps to the last date for the current ItemCode. The idea is that the user will have a record up on the screen and that record has a particular ItemCode. When they press this button, the form will jump to the record that has the highest PriceDate for that ItemCode.
What is the best way to do this?
Thanks in advance!