Get a table value

[maximark]

All of a sudden, my mind has gone blank, under fire here too

Access 2010
I have a table in the db_be called tbl_Version
in it is one field with one text value - CurrentVersion
if I want to retrieve it to compare it to lbl_Version.caption from my main login screen how do I code it.


at the end I have
If lbl_version.Caption = XXXXX (this is where I need to input version value from table) Then
'version is current and so continue
Else
'version is out of date so show a message and then exit
MsgBox "You are running an out of date version, Please reboot your machine"
GoTo Exit_cmdContinue_Click
End If

so that rebooting will/should load newest version from network

 

[plog]

Dlookup (http://www.techonthenet.com/access/functions/domain/dlookup.php)

 

[pbaldy]

You could use a DLookup() if there's one record, DMax() if more.

 

[maximark]

thanks guys - looking into it

you two nailed it the Dlookup is working perfectly

Thanks to you both for a quick reply

.