My form will prompt the user for Part Number.
In the table the records look like this:
PartNumber CreateDate LastSerialNumber
1 1/1/2011 1
1 1/1/2011 10
1 1/1/2011 20
I need the vba code to return the record with the '20'. In this table there are many different part numbers, dates, and serial numbers. I need the record with the last serial number used for that part number and most recent date.