Re: Form for parameter query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Thu, 3 Mar 2005 08:37:06 -0800

Thanks for the help. I got it figured out.

"scoopy2" wrote:

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

Quantcast