Referencing columns from a combo box adds extra brackets

W

Wendy

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
 
W

Wendy

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

Steve Schapel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List box selection into combo box 2
Combo box selection updates multiple source fields in underlying t 1
Combo Columns 1
Form Combo Box 2
Pulling values from columns in a combo box. 3
Combo Box Columns Null during On Current event 3
What is the extra field added with a combo or list box 2
Combo box help please 5

Top