Combo Box Display

  • Thread starter Thread starter Lamar
  • Start date Start date
L

Lamar

I using the Combo Box Wizard and I choose "Find a record on my form based on
the value..." I select two fields - "Office ID" and "Office Name" to use to
select the records in my combo box. It works fine for showing the records on
my form but I want both fields to display in my combo box after the selection.

In my combo box if I select Office ID "100" and Office Name "Redwood" then
it shows just "100" in my combo box. I want it show "100" and "Redwood" in
combo box after the selection. Is this possible?

Thanks for any help - Lamar
 
I using the Combo Box Wizard and I choose "Find a record on my form basedon
the value..."  I select two fields - "Office ID" and "Office Name" to use to
select the records in my combo box.  It works fine for showing the records on
my form but I want both fields to display in my combo box after the selection.

In my combo box if I select Office ID "100" and Office Name "Redwood" then
it shows just "100" in my combo box.  I want it show "100" and "Redwood" in
combo box after the selection.  Is this possible?

Thanks for any help - Lamar
Click to expand...

Yes this is possible. Go to the combo box wizard, create two fields.
Go to "I will type the values that I want".

So field 1 will be Office ID, and Field 2 will be Office Name.

Then in the combo box properties, make sure that both columns shows,
but bind the data to only one column, of whatever datatype the table
field is,

Set the column widths like this in the combo box control properties:
1";1" in the format tab. You can play around with the column width
settings.
 
Go into the properties of your combo box
In the Data Tab Go to the rowsource (that will be a query)
Create a field (maybe called OfficeIDName) =[Office Id] & " " & [Office
Name]
The first column in your query should be [office id] the second should
be the new column
Leave the bound column at 1 (Office ID will be stored as the value in
the combo box)

In the Format Tab for your combo box, set number of columns to 2 and set the
column widths to 0",2" (Only the second column will show in the combo box,
it will have both the ID and the Name showing the 2" measurement should be
adjusted to fit the names you have)

Tom
 
This will show both office id and office name while selecting the value you
want, but Office Name will not be left in the box AFTER the selection.

I using the Combo Box Wizard and I choose "Find a record on my form based
on
the value..." I select two fields - "Office ID" and "Office Name" to use
to
select the records in my combo box. It works fine for showing the records
on
my form but I want both fields to display in my combo box after the
selection.

In my combo box if I select Office ID "100" and Office Name "Redwood" then
it shows just "100" in my combo box. I want it show "100" and "Redwood" in
combo box after the selection. Is this possible?

Thanks for any help - Lamar
Click to expand...

Yes this is possible. Go to the combo box wizard, create two fields.
Go to "I will type the values that I want".

So field 1 will be Office ID, and Field 2 will be Office Name.

Then in the combo box properties, make sure that both columns shows,
but bind the data to only one column, of whatever datatype the table
field is,

Set the column widths like this in the combo box control properties:
1";1" in the format tab. You can play around with the column width
settings.
 
Back
Top