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

--------------------------------------------------------------------------------
Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 1433 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!

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


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Gil Stone" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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