Parameters and SQL / DLookup code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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)
 
Back
Top