DLookup()

[jgelpi16]

I am trying to verify a field in a table. Very simple. The table will always have 1 record in it, and there is only one column in the table....I feel stupid asking this question...How do you use DLookup() in this situation to return the value? I know how to use it if you want to look up a value where another field is equal to something....Here is what I am going for...

varExportCheck = DLookup("[ExportCheck]", "tblExportCheck", [ExportCheck])

All I want to return is the value of ExportCheck.

[pbaldy]

With one record, you don't need the third argument (which you have the wrong syntax for).

[jgelpi16]

Well that is what I thought but it kept throwing another error (I cannot remember). I just ended up adding a second field. Thank you.