Referencing combo box column

  • Thread starter Thread starter wingus
  • Start date Start date
W

wingus

Hi

Using A2003, SQL Server 2005.

I have a combo box on a form controlled by a sproc, very simple, just
two columns ordered by second column.

I have another text box with a reference to the second column of the
combo box as "=cbo_debtor.column(1)".

My issue is this: if I have aliases in my sproc, ie. SELECT
THISCOLUMN AS THISNAME etc. then the text box shows nothing. If I
take the aliases away, then it displays the correct information. I'm
just wanting to make the headers in the combo box a bit more
meaningful than the table column names.

Can anyone explain this or has anyone else experienced it?

Thanks
Winsa
 
No problem here with A2003 and SQL-Server 2000 or 2005.

Are you sure that you are not introducing some other syntaxe error when
adding your aliases? Did you make sure to close/reopen your ADP project so
to be sure that everything has been refreshed?
 
Back
Top