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