ComboBox Parameter Problem

[jackle]

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle

 

[Sprinks]

The genius Steven Lebans has the solution to your problem at www.lebans.com.

Look for "AutoSizeTextBox".

Sprinks

 

[Klatuu]

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

 

[jackle]

I NEED to see the 2nd column to understand what the first column means. I am
having problems probably because of this. My "Bount to Column" is listed as 1
(which is what displays in the combobox after i select the itme i need to
select.). i would think that if the value form the 1st column is the only
thing showing in the combo box (after selection) that would be the value
passed to the query parameter. Or do i need to include something in the query
grid to select only the value from the 1st column?
thanks,
Jackle

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle

 

[Klatuu]

The bound column does not need to be visible to be used. In fact, if it is
just a code value that the user will not understand, it is best to hide it
and use something meaningful to us humans. So, if you want your first column
to be the bound column, but you want the second column to be displayed, then
the Column Width property should be 0";1.5" (or however wide it needs to be
to display the column). It makes no difference in the behaviour of the combo
box or how it is used. Just remember, if you are addressing the combo box by
column (Me.MyCombo.Column(0) ) that the first column is 0. So, Me.MyCombo is
the same as Me.MyCombo.Column(0). Also, the first column does not have to be
the bound column. It can be any column.

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle

 

[jackle]

Can this be done in a query or query design grin (preferably). if it needs to
be done thru code, i am cluless to programing. can you advide further?
Thanks,
jackle

The bound column does not need to be visible to be used. In fact, if it is
just a code value that the user will not understand, it is best to hide it
and use something meaningful to us humans. So, if you want your first column
to be the bound column, but you want the second column to be displayed, then
the Column Width property should be 0";1.5" (or however wide it needs to be
to display the column). It makes no difference in the behaviour of the combo
box or how it is used. Just remember, if you are addressing the combo box by
column (Me.MyCombo.Column(0) ) that the first column is 0. So, Me.MyCombo is
the same as Me.MyCombo.Column(0). Also, the first column does not have to be
the bound column. It can be any column.

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle

 

[Klatuu]

Yes, build the query you need to return the data you want, then for the field
in the table that equates to the value in the combo box, reference the combo
box in the Criteria row:
[forms]![MyFormName]![MyComboBox]

Can this be done in a query or query design grin (preferably). if it needs to
be done thru code, i am cluless to programing. can you advide further?
Thanks,
jackle

The bound column does not need to be visible to be used. In fact, if it is
just a code value that the user will not understand, it is best to hide it
and use something meaningful to us humans. So, if you want your first column
to be the bound column, but you want the second column to be displayed, then
the Column Width property should be 0";1.5" (or however wide it needs to be
to display the column). It makes no difference in the behaviour of the combo
box or how it is used. Just remember, if you are addressing the combo box by
column (Me.MyCombo.Column(0) ) that the first column is 0. So, Me.MyCombo is
the same as Me.MyCombo.Column(0). Also, the first column does not have to be
the bound column. It can be any column.

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

:

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle

 

[jackle]

OK, I feel like a real idiot. I was doung the
[forms]![MyFormName]![MyComboBox] thing but it was giving me an error. I just
checked the spelling and my combobox name was misspelled in the query, so it
wasn't matching the combobox name in the form. "Always check all details
before bungee jumping! You don't want to turn yourself into chunky salsa!"

Yes, build the query you need to return the data you want, then for the field
in the table that equates to the value in the combo box, reference the combo
box in the Criteria row:
[forms]![MyFormName]![MyComboBox]

Can this be done in a query or query design grin (preferably). if it needs to
be done thru code, i am cluless to programing. can you advide further?
Thanks,
jackle

The bound column does not need to be visible to be used. In fact, if it is
just a code value that the user will not understand, it is best to hide it
and use something meaningful to us humans. So, if you want your first column
to be the bound column, but you want the second column to be displayed, then
the Column Width property should be 0";1.5" (or however wide it needs to be
to display the column). It makes no difference in the behaviour of the combo
box or how it is used. Just remember, if you are addressing the combo box by
column (Me.MyCombo.Column(0) ) that the first column is 0. So, Me.MyCombo is
the same as Me.MyCombo.Column(0). Also, the first column does not have to be
the bound column. It can be any column.

:

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

:

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle

 

[Klatuu]

Silly you I never make mistrakes

OK, I feel like a real idiot. I was doung the
[forms]![MyFormName]![MyComboBox] thing but it was giving me an error. I just
checked the spelling and my combobox name was misspelled in the query, so it
wasn't matching the combobox name in the form. "Always check all details
before bungee jumping! You don't want to turn yourself into chunky salsa!"

Yes, build the query you need to return the data you want, then for the field
in the table that equates to the value in the combo box, reference the combo
box in the Criteria row:
[forms]![MyFormName]![MyComboBox]

Can this be done in a query or query design grin (preferably). if it needs to
be done thru code, i am cluless to programing. can you advide further?
Thanks,
jackle

:

The bound column does not need to be visible to be used. In fact, if it is
just a code value that the user will not understand, it is best to hide it
and use something meaningful to us humans. So, if you want your first column
to be the bound column, but you want the second column to be displayed, then
the Column Width property should be 0";1.5" (or however wide it needs to be
to display the column). It makes no difference in the behaviour of the combo
box or how it is used. Just remember, if you are addressing the combo box by
column (Me.MyCombo.Column(0) ) that the first column is 0. So, Me.MyCombo is
the same as Me.MyCombo.Column(0). Also, the first column does not have to be
the bound column. It can be any column.

:

You just need to adjust the Column Width property of your Combo Box. A width
of 0 means the column will not display. For multiple column Combo Boxes, the
Column Width propertry will be a list of numbers separated by ;
So a 3 column combo box where the first and third columns are visible but
the second is not could be something like: 1";0";1.5"

:

i have a form that has a multi-column combo box. this combo box is the source
for a parameter query, [Forms]![frmMoreControlsForm].[cboRejectSource]. The
multi column combo box is presentiung problems. i get an
"Forms!frmMoreControlsForm.cboRejectSource" as a popup box message and i have
to manually type in the combobox's value in the 1st column. It is the 1st
column that needs to be picked up in the parameter query. how can i make that
happen? when you select the item in the combo box, only the 1st column is
displayed. I need the 2nd column to be displayed so you can tell what the
'code' value is for the parameter.
Thanks for any help,
Jackle