Form not passing parameters to query

[callie_sunrise]

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]

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]

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

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

 

[callie_sunrise]

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

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

 

[callie_sunrise]

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

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

 

[callie_sunrise]

Apologies for the multiple posts... not sure what went on then!

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

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

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/

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

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

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