OrdeBy works in A2000 but not in A2007

I have a form with

Me.OrderBy = "qExportResponseTableWithCFs.CF1"

This works in A2000 but not in A2007.

Re: OrdeBy works in A2000 but not in A2007

On Oct 19, 1:03 pm, "Karl" wrote:
> I have a form with
>
> Me.OrderBy = "qExportResponseTableWithCFs.CF1"
>
> This works in A2000 but not in A2007.

Thanks for letting us know!

Re: OrdeBy works in A2000 but not in A2007

Karl wrote:
> I have a form with
>
> Me.OrderBy = "qExportResponseTableWithCFs.CF1"
>
> This works in A2000 but not in A2007.
>
What happens if you do
Me.OrderBy = "CF1"
Me.Orderbyon = True
?

Re: OrdeBy works in A2000 but not in A2007

On Oct 19, 1:03 pm, "Karl" wrote:
> I have a form with
>
> Me.OrderBy = "qExportResponseTableWithCFs.CF1"
>
> This works in A2000 but not in A2007.

"When you save a form with a recordsource, all of the underlying
fields are
saved in the form's typeinfo and thus can be accessed via the dot
syntax. "
- Michka

Is it possible that the conversion to Access 2007 removes the
redundant (not used as control sources) fields in the typeinfo, and
thus, the form no longer knows what CF1 is?

Re: OrdeBy works in A2000 but not in A2007

me.orderbyon works for me in 2007, by the way.

I always use both statements:

me.orderby = "CF1"
me.orderbyon = true


"Karl" wrote in message
news:er5Si.45680$RX.13176@newssvr11.news.prodigy.net...
>I have a form with
>
> Me.OrderBy = "qExportResponseTableWithCFs.CF1"
>
> This works in A2000 but not in A2007.
>
>
>
>