If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Referencing columns from a combo box adds extra brackets
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 |
#2
|
|||
|
|||
Referencing columns from a combo box adds extra brackets
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. "Wendy" wrote: 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 |
#3
|
|||
|
|||
Referencing columns from a combo box adds extra brackets
Good news, Wendy. Yes, a cup of tea was exactly what I was about to
suggest. g -- Steve Schapel, Microsoft Access MVP Wendy wrote: 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. |
Thread Tools | |
Display Modes | |
|
|