cascading query problem

[mike@work]

hi,
i'm running office 2007 and have run into a strange problem.
i have a query which has 2 fields. 1 is a unique ref number where each
number appears more than once and the other is a date field which is used for
criterea.
i then have a cascading query which only contains the unique ref number
field. this field is then totalled by "group by" so that i can count the
number of individual unique ref numbers over a time period. this all works
fine, but..
i create a form linked to the sub query with a textbox that contains the
formula =count([uniquereferencenumber]). when i open this form it asks me for
the date field in the original query. if i include this field i cannot group
by the ref numbers.
this all worked fine in access 2003, can anyone shed any light plz?

 

[mike@work]

i solved this myself...
the forms "order by" property was automatically set to the date field in the
orginal query. this was not the case in access 2003. i guess its another case
of MS trying to help us out!