Form not passing parameters to query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
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,

Jeff Boyce said:
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?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

callie_sunrise said:
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!!!
Click to expand...
Click to expand...
 
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,

Jeff Boyce said:
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?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

callie_sunrise said:
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!!!
Click to expand...
Click to expand...
 
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,

Jeff Boyce said:
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?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

callie_sunrise said:
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!!!
Click to expand...
Click to expand...
 
Apologies for the multiple posts... not sure what went on then!

callie_sunrise said:
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,

Jeff Boyce said:
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?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

callie_sunrise said:
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!!!
Click to expand...
Click to expand...
Click to expand...
 
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...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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


callie_sunrise said:
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,

Jeff Boyce said:
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?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

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
Click to expand...
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
Click to expand...
return
any
data.

Any ideas anyone?

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

Much appreciated all!!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top