Re: Form for parameter query

From: scoopy2 (scoopy2_at_discussions.microsoft.com)
Date: 03/02/05 

Date: Wed, 2 Mar 2005 12:47:03 -0800

No multiple selections or anything. Trying to keep it as simple as possible
as I work my way up to the access novice that I was. I know without seeing
it the question is vague, just thoguht someone might have a thought on it.
Thanks

"Ken Snell [MVP]" wrote:

> Are you making multiple selections in the listbox? If yes, then your setup
> will not work. You must use code to generate the query if you use a
> multiselect listbox on a form as a source of the criteria.
>
> See this article on The ACCESS Web for info about multiselect listboxes in
> queries:
> http://www.mvps.org/access/forms/frm0007.htm
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "scoopy2" <scoopy2@discussions.microsoft.com> wrote in message
> news:5F6AE75D-80DD-4286-BE94-60E0D9BFF56A@microsoft.com...
> > First off, I did go back and do a search in the forum and used that info
> > to
> > get started. Thanks to all that contribute. I set up a form with a list
> > box
> > and control button to run my query based on the list box selection. In
> > the
> > query I referneced the form and list box for criteria. When I run the
> > query
> > from the form, my list box looks great and includes all my selections but
> > comes up blank when run. Right now this is a very simple DB - one table,
> > one
> > query, one form. I'm sure I'm just missing something. Anyone got any
> > ideas?
> > I'm trying to get back into using access after several years away and it
> > obviously isn't going too well. Thanks
>
>
>