Dlookup Q:

[Gil Stone]

Hi,
I use
If Nz(DLookup("[Version]", "[tblFileversion]"), "") = "20061218" Then
Me.Visible = False
to check the last file version.
How do I point DLookup to the last table autonumber's entry?
TIA
Gil

 

[Douglas J. Steele]

Assuming the AutoNumber is set to Increment, rather than Random, you should
be able to use DMax.