Parameters and SQL / DLookup code?

[Guest]

What characters are needed to assure that parameters passed into SQL and
Dlookup queries are parsed so the query executes with the variable query
parameters ? The working environment is MS Access. None parameter /
variable based queries seem to work ok but when variables defined via list
boxes are introduced it seems there are special needs to processing the
parameters passed
to the functions...

 

[david epsom dot com dot au]

Please give examples.

There are problems with list boxes: check
that the parameter read from the list box
is actually correct. You may want to remove
the "DISTINCT" key word from an query in the
Record Source of the list box.

(david)