Open form to specific record?

[WinDancer]

I need to open a form to the newest record - the largest TrackingNumber.

What is the cleanest way to do this?

Thanks,
Dave

 

[pbaldy]

You could use this technique:

http://www.baldyweb.com/wherecondition.htm

with a DMax to get the largest tracking number instead of getting the value from the form.

 

[WinDancer]

Thanks, I will go read up on DMax.
Dave