Re: Form for parameter query

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

Date: Thu, 3 Mar 2005 07:41:02 -0800

Sorry. Guess some of that info would help. I can get the query to run
directly but comes up empty when I run it from the command button on the
form. The query SQL is:

SELECT [full database].ID, [full database].School, [full database].street,
[full database].city, [full database].state, [full database].zip, [full
database].County, [full database].Region, [full database].Phone, [full
database].lower, [full database].upper, [full database].Full_District, [full
database].Short_District, [full database].Name, [full database].Position,
[full database].Email
FROM [full database]
WHERE ((([full database].School)=[forms]![Form1]![List0]));

The list box displays the field School. The form is Form1 and the listbox
is List0. Thanks

"John Vinson" wrote:

> 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]
>