Retrieving a field value by directly accessing a table

[ddelk]

I need to get the value of a field and store it to a variable. Is there a way to reference the table directly rather than go through the process of creating a recordset or writing a query? Something like

intValue = tablename.fieldname.value

 

[RoyVidar]

Not really, you have the domain aggregate functions, though (DLookup, DSum, Dmax...)

Roy-Vidar

 

[PaulF]

check out DLookUp

PaulF