unbound control

  • Thread starter Thread starter macamarr
  • Start date Start date
M

macamarr

Hello, below is the info for a combo box on my form. All
the information I am looking for is in the combobox, but
what I would like to do is have unbound text boxes fill
with information from each column.

SELECT [qryDelLoc].[CusNum], [qryDelLoc].[CusDesc],
[qryDelLoc].[CusAddress], [qryDelLoc].[Route], [qryDelLoc].
[Stop] FROM qryDelLoc;


example:
txtCusNum 'fill with CusNum from combobox
txtCusDesc ' Fill with CusDesc from combobox
txtCusAddress...
txtRoute...
txtStop...

I can only get this to work with the bound column from the
cbo. Is it possible to have more than one bound column in
a cbo or am I just crazy!
 
macamarr said:
Hello, below is the info for a combo box on my form. All
the information I am looking for is in the combobox, but
what I would like to do is have unbound text boxes fill
with information from each column.

SELECT [qryDelLoc].[CusNum], [qryDelLoc].[CusDesc],
[qryDelLoc].[CusAddress], [qryDelLoc].[Route], [qryDelLoc].
[Stop] FROM qryDelLoc;


example:
txtCusNum 'fill with CusNum from combobox
txtCusDesc ' Fill with CusDesc from combobox
txtCusAddress...
txtRoute...
txtStop...

I can only get this to work with the bound column from the
cbo. Is it possible to have more than one bound column in
a cbo or am I just crazy!
Click to expand...


To refer to the strings displayed in other columns of a
combo or list box, you can use the control's Column
property. E.g. set the txtCusNum text box's expression to:
=combobox.Column(0)
and txtCusDesc:
=combobox.Column(1)
etc.
 
Back
Top