Re: Form for parameter query

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/02/05


Date: Wed, 02 Mar 2005 14:37:52 -0700

On Wed, 2 Mar 2005 10:29:04 -0800, "scoopy2"
<scoopy2@discussions.microsoft.com> wrote:

>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

What "comes up blank"? The Form? The Query? Could you post the SQL of
the query and indicate what the listbox contains?

                  John W. Vinson[MVP]


Loading