Referencing combo box column

From: wingus@xxxxxxxxxxxxxxx
Date: 26 Feb 2007 19:16:40 -0800

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

.

Prev by Date: Re: INT IDENTITY Field Question
Next by Date: archiving data
Previous by thread: Re: INT IDENTITY Field Question
Next by thread: archiving data
Index(es):
- Date
- Thread

Relevant Pages

Re: Referencing combo box column
... Sylvain Lafontaine, ing. ... I have a combo box on a form controlled by a sproc, very simple, just ... I have another text box with a reference to the second column of the ... if I have aliases in my sproc, ...
(microsoft.public.access.adp.sqlserver)
Re: Newbe question
... >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA ... >Columnist, SQL Server Professional ... >The second column contains data that I want to move to ...
(microsoft.public.sqlserver.security)
Re: update table with matlab
... I connected Matlab with Ms sql server, and I have to insert 4 column of ... exdata = ... if I use insert command, I obtain the second column that start ...
(comp.soft-sys.matlab)
Re: Newbe question
... , Col2 = NULL ... SQL Server MVP ... Columnist, SQL Server Professional ... The second column contains data that I want to move to the third column. ...
(microsoft.public.sqlserver.security)