Combobox display question

[Chad Cameron]

Hi All,

When I click my combobox, it shows me 2 columns. When I select an item, it
only shows me 1 column. In searching I found that the combobox will only
display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox right
behind it to display my next column of the combobox. Now I need the textbox
to look at column 2 of my combobox. If I put =cbProcedureNum in the control
source it shows me the bound column, is there a way to offset it by 1?

Thanks everyone for the awesome support,
Chad

 

[Gina Whipp]

Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[KARL DEWEY]

I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " --- Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.

Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

When I click my combobox, it shows me 2 columns. When I select an item,
it only shows me 1 column. In searching I found that the combobox will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I need the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum in
the control source it shows me the bound column, is there a way to offset
it by 1?

Thanks everyone for the awesome support,
Chad

 

[Gina Whipp]

Karl,

Interesting, never thought of that... might have to give that a try!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " ---
Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.

Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

When I click my combobox, it shows me 2 columns. When I select an
item,
it only shows me 1 column. In searching I found that the combobox will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I need
the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum
in
the control source it shows me the bound column, is there a way to
offset
it by 1?

Thanks everyone for the awesome support,
Chad

 

[Jeff Boyce]

Gina

Actually, you may have done something similar already ... consider looking
for a person in a combobox ...

Having LName, FName is convenient, no?
Jeff B.

Karl,

Interesting, never thought of that... might have to give that a try!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " ---
Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.

Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

When I click my combobox, it shows me 2 columns. When I select an
item,
it only shows me 1 column. In searching I found that the combobox
will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I need
the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum
in
the control source it shows me the bound column, is there a way to
offset
it by 1?

Thanks everyone for the awesome support,
Chad

 

[Gina Whipp]

Jeff,

i usually put that in the Tool Tip, never occured to me to just have it in
the combo box. Who is that says "...more than one way to skin a cat..."

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina

Actually, you may have done something similar already ... consider looking
for a person in a combobox ...

Having LName, FName is convenient, no?
Jeff B.

Karl,

Interesting, never thought of that... might have to give that a try!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

I use a calculated field like this --
SELECT [Section].[Section], "Section "&[Section].[Section] & " ---
Building
"& [Section].[BLDG]& " - Room "& [Section].[ROOM] FROM [Section] ORDER
BY
[Section];
with column widths - 0"; 2.5"

--
Build a little, test a little.


:

Chad,

You need to tell you text box which Column to display, try...

=[cbProcedureNum].[Column](1)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

When I click my combobox, it shows me 2 columns. When I select an
item,
it only shows me 1 column. In searching I found that the combobox
will
only display 1 column when not selected. Is this true?

If so, I shrunk my combobox to only show 1 column. I added a textbox
right behind it to display my next column of the combobox. Now I
need the
textbox to look at column 2 of my combobox. If I put =cbProcedureNum
in
the control source it shows me the bound column, is there a way to
offset
it by 1?

Thanks everyone for the awesome support,
Chad