View Single Post
  #3  
Old May 25th, 2010, 09:17 PM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default 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