Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / June 2007

Tip: Looking for answers? Try searching our database.

Form not passing parameters to query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
callie_sunrise - 27 Jun 2007 14:44 GMT
Hi All,

Right, I have form with an unbound drop down list using a column in a table
for a row source.
I also have a query returning results from the same table.

I have setup the query to use critieria [Forms]![frmname]![dropdownlistname]
on the column concerned to look at the above form and the drop down list for
the paramter.

I have even double checked that I'm doing it correctly here
http://office.microsoft.com/en-us/access/HA011170771033.aspx.

However, for some reason the form just doesnt pass through the parameter
from the drop down list into the query.  The query runs but doesnt return any
data.

Any ideas anyone?

I'd be happy to send you anything you needed :-)

Much appreciated all!!!
Jeff Boyce - 27 Jun 2007 15:02 GMT
Just a wild guess...

One of the fields involved in this situation is defined as a lookup data
type in the table ... if so, this could be the problem.

If you make a copy of the query and substitute an actual value, does it
work?

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> Hi All,
>
[quoted text clipped - 18 lines]
>
> Much appreciated all!!!
callie_sunrise - 27 Jun 2007 15:14 GMT
Hi Jeff,

Thank you for you prompt reply.

No, one of the fields is not a lookup data type I'm afraid.  It's just a
standard table.

Yes, substituting the [Forms]![frmname]![controlname] for actual value does
work.

Hope this helps.

Kind Regards,

> Just a wild guess...
>
[quoted text clipped - 30 lines]
> >
> > Much appreciated all!!!
callie_sunrise - 27 Jun 2007 15:14 GMT
Hi Jeff,

Thank you for you prompt reply.

No, one of the fields is not a lookup data type I'm afraid.  It's just a
standard table.

Yes, substituting the [Forms]![frmname]![controlname] for actual value does
work.

Hope this helps.

Kind Regards,

> Just a wild guess...
>
[quoted text clipped - 30 lines]
> >
> > Much appreciated all!!!
callie_sunrise - 27 Jun 2007 15:16 GMT
Hi Jeff,

Thank you for you prompt reply.

No, one of the fields is not a lookup data type I'm afraid.  It's just a
standard table.

Yes, substituting the [Forms]![frmname]![controlname] for actual value does
work.

Hope this helps.

Kind Regards,

> Just a wild guess...
>
[quoted text clipped - 30 lines]
> >
> > Much appreciated all!!!
callie_sunrise - 27 Jun 2007 15:24 GMT
Apologies for the multiple posts... not sure what went on then!

> Hi Jeff,
>
[quoted text clipped - 44 lines]
> > >
> > > Much appreciated all!!!
Jeff Boyce - 29 Jun 2007 13:49 GMT
When I have a query that doesn't behave, I try for a while and then throw it
out!  What happens if you create a totally new query from scratch, first
using the actual value, then using the [Forms]!... criterion?

By the way, the only way that [Forms]!... approach will be able to work is
if your form is actually open and there's a value in the control...

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> Hi Jeff,
>
[quoted text clipped - 44 lines]
> > >
> > > Much appreciated all!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.