lookup in query table

[hngo]

hi,

can we use dlookup to search for information in a query table. My problem
is that we have tables link to query via a calculated field.

many thanks in advance

 

[Arvin Meyer [MVP]]

hi,

can we use dlookup to search for information in a query table. My problem
is that we have tables link to query via a calculated field.

Both DLookup, and the much faster Recordset methods work on JET queries.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access