Referencing columns from a combo box adds extra brackets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy - 23 Mar 2008 18:56 GMT

Hi,
I've been used to using the .column property on a combo box to refer to the
other columns in the underlying data source; since using 2007 this doesn't
seem to work for me.

I put in the normal syntax and then Access goes and does this:
=[Activity Name].[Column](2)

additionally, the .column property isn't available in the expression builder.

Has this changed for 2007?

TIA

Reply to this Message

Wendy - 23 Mar 2008 19:06 GMT

Hey Guys,
It seems to work now - initially I was getting the old #Name, but after
getting a cup of tea, it all seems to work...tea really does fix everything
lol.

> Hi,
> I've been used to using the .column property on a combo box to refer to the
[quoted text clipped - 9 lines]
>
> TIA

Reply to this Message

Steve Schapel - 23 Mar 2008 19:57 GMT

Good news, Wendy. Yes, a cup of tea was exactly what I was about to
suggest. <g>

Signature

Steve Schapel, Microsoft Access MVP

> Hey Guys,
> It seems to work now - initially I was getting the old #Name, but after
> getting a cup of tea, it all seems to work...tea really does fix everything
> lol.

Reply to this Message