Display the very last record created

[WinDancer]

I need to open a form and display the last record created.

I tried this:
DoCmd.OpenForm "frmLocalRecords", , , "TrackingNumber=max()"

but all it does is crash the application...

any help, please?
Thanks,
Dave

 

[georgedwilkinson]

I didn't check the syntax of your whole statement but I'm immediately drawn to the "=max()"

Have you considered using DMax()? If you do that, you should look up the syntax in help. Also, be cautious about where you put calls to functions. Check out the help syntax for OpenForm and I think you'll find you need to put the =DMax(stuff in here) outside of the quotation marks.

 

[boblarson]

Yep, it would. You would have to do something liike this:

lngTN As Long
lngTN = DMax("TrackingNumber", "YourTableNameHere")

DoCmd.OpenForm "frmLocalRecords", , , "TrackingNumber = " & lngTN