Parameter queries that allow users to choose items from a list
XPS35 wrote:
=?Utf-8?B?dmVuYWpvZQ==?= wrote:
A parameter query is not the right way to do this.
Make a form with an unbound combobox. The rowsource of the combo would
look like:
SELECT DISTINCT LastName FROM tblAuthorLastNames (why first names and
last names in seperate tables?).
In the condition part of a query you can refer to the combo
(forms!yourform!yourcombo).
.... which makes it a parameter query ... ;-)
--
HTH,
Bob Barrows
|