DLookup

Use this action to retrieve the value of a single database field or expression. The retrieved database value is then used to set the value of a target variable.

Property	Description
Expression	Field or expression to be used in the SELECT clause of the SQL statement to be executed.
Domain	Table or view name to be used in the FROM clause of the SQL statement to be executed.
Criteria	Criteria to be used in the WHERE clause of the SQL statement to be executed.
Connection	Connection from which the database value will be retrieved.
Convert result to	Data type to which the retrieved value should be converted. The type specified must comply with the nature of the value to be retrieved i.e. a string cannot be converted to an integer. The possible data types are Text, Integer, Float, Date, Boolean and Memo.
Type Of Target	Type of variable which will receive the retrieved database value [Control, variable, expression, session, application, cookie].
Target	Name of the variable which will receive the retrieved database value.