DLookup() is the simplest method for pulling a single field or expression
from a table or saved query.
--
Duane Hookom
MS Access MVP
Quote:
> I am a little embarrassed to ask this question since it is
> so basic. Can somebody give me generic code for
> capturing the results of a query. I usually pull values
> from forms, but in this case I just need a piece of info
> from a table. I know how to use loops, but rarely do.
> Your help would be greatly appreciated.
> Paul Hammond
> Richmond, VA
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.*-*-*.com/ ).
Version: 6.0.422 / Virus Database: 237 - Release Date: 11/20/2002
Simple Problem