Shown column of combo box = value ?

[...]

Hi,

I have a problem with combo box based on query that catches values from two
tables. One of the columns is ID which value I need from combo box in order
to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order to show
row in query with ID=0) combo box shows 0 in combo box. OK I need ID to work
with, but I do not need user to see it. How to change this (combo box should
show some other column from query different from ID, but take ID as value
when selected)?

This is query that combo box relies to (works ok):
SELECT [qryDrzava_Grad].[IDgrada], [qryDrzava_Grad].[ImeGrada],
[qryDrzava_Grad].[PostBr], [qryDrzava_Grad].[Oblast],
[qryDrzava_Grad].[Drzava] FROM qryDrzava_Grad;

How to show for example [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] in the first column of combo box, but when choice
is made to store value of [qryDrzava_Grad].[IDgrada]? Seems to me that the
first column is the column that combo box picks values from. I do not need
at all to show [qryDrzava_Grad].[IDgrada]. How to prevent column from
showing in combo box, but taking its value when choice is made?

Thank you in advance.

Best regards,
Stosic Dejan.

 

[Guest]

If you want the users to hide the first column set the ColumnWidth property
of the combo box like this:

0;5

and set ColumnCount property as "2"


That means that the first column has zero width.

 

[...]

How to show value from column [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] when form is opened (now it shows 0).

Thanks in advance.

Best regards,
Stosic Dejan.

If you want the users to hide the first column set the ColumnWidth property
of the combo box like this:

0;5

and set ColumnCount property as "2"


That means that the first column has zero width.

Hi,

I have a problem with combo box based on query that catches values from two
tables. One of the columns is ID which value I need from combo box in order
to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order to show
row in query with ID=0) combo box shows 0 in combo box. OK I need ID to work
with, but I do not need user to see it. How to change this (combo box should
show some other column from query different from ID, but take ID as value
when selected)?

This is query that combo box relies to (works ok):
SELECT [qryDrzava_Grad].[IDgrada], [qryDrzava_Grad].[ImeGrada],
[qryDrzava_Grad].[PostBr], [qryDrzava_Grad].[Oblast],
[qryDrzava_Grad].[Drzava] FROM qryDrzava_Grad;

How to show for example [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] in the first column of combo box, but when choice
is made to store value of [qryDrzava_Grad].[IDgrada]? Seems to me that the
first column is the column that combo box picks values from. I do not need
at all to show [qryDrzava_Grad].[IDgrada]. How to prevent column from
showing in combo box, but taking its value when choice is made?

Thank you in advance.

Best regards,
Stosic Dejan.

 

[Guest]

As I understand the source of the combo box is the query with 5 columns.
The first column is the ID number, which you want to store but not to show.

So, open the form in design view, right-click on the combo box and select
"Properties"

Set the properties as follows:

ColumnCount: 5
ColumnWidth: 0;2;2;2;2
ListWidth: 8
BoundColumn: 1

The users will not see the first (ID) column, but the value will be taken
when the choice is made...

How to show value from column [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] when form is opened (now it shows 0).

Thanks in advance.

Best regards,
Stosic Dejan.

If you want the users to hide the first column set the ColumnWidth property
of the combo box like this:

0;5

and set ColumnCount property as "2"


That means that the first column has zero width.

Hi,

I have a problem with combo box based on query that catches values from two
tables. One of the columns is ID which value I need from combo box in order
to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order to show
row in query with ID=0) combo box shows 0 in combo box. OK I need ID to work
with, but I do not need user to see it. How to change this (combo box should
show some other column from query different from ID, but take ID as value
when selected)?

This is query that combo box relies to (works ok):
SELECT [qryDrzava_Grad].[IDgrada], [qryDrzava_Grad].[ImeGrada],
[qryDrzava_Grad].[PostBr], [qryDrzava_Grad].[Oblast],
[qryDrzava_Grad].[Drzava] FROM qryDrzava_Grad;

How to show for example [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] in the first column of combo box, but when choice
is made to store value of [qryDrzava_Grad].[IDgrada]? Seems to me that the
first column is the column that combo box picks values from. I do not need
at all to show [qryDrzava_Grad].[IDgrada]. How to prevent column from
showing in combo box, but taking its value when choice is made?

Thank you in advance.

Best regards,
Stosic Dejan.

 

[...]

Thank you very much. That solved problem completely.

One more question: I have this combobox that relies to query and another one
that relies to table. Is it possible to connect behaviour of second one
regarding choice in first one? For example, user choose one option in first
combobox, and as this choice has already value for other combobox I would
like to set (and show) this value there in this second combobox (so user do
not need to search this value). Possible or not? When I give combobox
value, it accepts this value, but do not show it in combobox on form.

Best regards,
Stosic Dejan.

As I understand the source of the combo box is the query with 5 columns.
The first column is the ID number, which you want to store but not to show.

So, open the form in design view, right-click on the combo box and select
"Properties"

Set the properties as follows:

ColumnCount: 5
ColumnWidth: 0;2;2;2;2
ListWidth: 8
BoundColumn: 1

The users will not see the first (ID) column, but the value will be taken
when the choice is made...

How to show value from column [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] when form is opened (now it shows 0).

Thanks in advance.

Best regards,
Stosic Dejan.

If you want the users to hide the first column set the ColumnWidth property
of the combo box like this:

0;5

and set ColumnCount property as "2"


That means that the first column has zero width.





:

Hi,

I have a problem with combo box based on query that catches values

from
two

tables. One of the columns is ID which value I need from combo box

in
order

to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order

to
show

row in query with ID=0) combo box shows 0 in combo box. OK I need ID

to
work

with, but I do not need user to see it. How to change this (combo

box
should

show some other column from query different from ID, but take ID as value
when selected)?

This is query that combo box relies to (works ok):
SELECT [qryDrzava_Grad].[IDgrada], [qryDrzava_Grad].[ImeGrada],
[qryDrzava_Grad].[PostBr], [qryDrzava_Grad].[Oblast],
[qryDrzava_Grad].[Drzava] FROM qryDrzava_Grad;

How to show for example [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] in the first column of combo box, but

when
choice

is made to store value of [qryDrzava_Grad].[IDgrada]? Seems to me

that
the

first column is the column that combo box picks values from. I do

not
need

at all to show [qryDrzava_Grad].[IDgrada]. How to prevent column from
showing in combo box, but taking its value when choice is made?

Thank you in advance.

Best regards,
Stosic Dejan.

 

[...]

Found that I have made mistake giving as value name instead of ID.
Everything 5.

Best regards,
Stosic Dejan.

Thank you very much. That solved problem completely.

One more question: I have this combobox that relies to query and another one
that relies to table. Is it possible to connect behaviour of second one
regarding choice in first one? For example, user choose one option in first
combobox, and as this choice has already value for other combobox I would
like to set (and show) this value there in this second combobox (so user do
not need to search this value). Possible or not? When I give combobox
value, it accepts this value, but do not show it in combobox on form.

Best regards,
Stosic Dejan.

As I understand the source of the combo box is the query with 5 columns.
The first column is the ID number, which you want to store but not to show.

So, open the form in design view, right-click on the combo box and select
"Properties"

Set the properties as follows:

ColumnCount: 5
ColumnWidth: 0;2;2;2;2
ListWidth: 8
BoundColumn: 1

The users will not see the first (ID) column, but the value will be taken
when the choice is made...

How to show value from column [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] when form is opened (now it shows 0).

Thanks in advance.

Best regards,
Stosic Dejan.

If you want the users to hide the first column set the ColumnWidth
property
of the combo box like this:

0;5

and set ColumnCount property as "2"


That means that the first column has zero width.





:

Hi,

I have a problem with combo box based on query that catches values from
two
tables. One of the columns is ID which value I need from combo box in
order
to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order to
show
row in query with ID=0) combo box shows 0 in combo box. OK I need

ID

to

work
with, but I do not need user to see it. How to change this (combo box
should
show some other column from query different from ID, but take ID as
value
when selected)?

This is query that combo box relies to (works ok):
SELECT [qryDrzava_Grad].[IDgrada], [qryDrzava_Grad].[ImeGrada],
[qryDrzava_Grad].[PostBr], [qryDrzava_Grad].[Oblast],
[qryDrzava_Grad].[Drzava] FROM qryDrzava_Grad;

How to show for example [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] in the first column of combo box, but when
choice
is made to store value of [qryDrzava_Grad].[IDgrada]? Seems to me that
the
first column is the column that combo box picks values from. I do not
need
at all to show [qryDrzava_Grad].[IDgrada]. How to prevent column from
showing in combo box, but taking its value when choice is made?

Thank you in advance.

Best regards,
Stosic Dejan.

 

[Guest]

The tips are here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209595

http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

Thank you very much. That solved problem completely.

One more question: I have this combobox that relies to query and another one
that relies to table. Is it possible to connect behaviour of second one
regarding choice in first one? For example, user choose one option in first
combobox, and as this choice has already value for other combobox I would
like to set (and show) this value there in this second combobox (so user do
not need to search this value). Possible or not? When I give combobox
value, it accepts this value, but do not show it in combobox on form.

Best regards,
Stosic Dejan.

As I understand the source of the combo box is the query with 5 columns.
The first column is the ID number, which you want to store but not to show.

So, open the form in design view, right-click on the combo box and select
"Properties"

Set the properties as follows:

ColumnCount: 5
ColumnWidth: 0;2;2;2;2
ListWidth: 8
BoundColumn: 1

The users will not see the first (ID) column, but the value will be taken
when the choice is made...

How to show value from column [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] when form is opened (now it shows 0).

Thanks in advance.

Best regards,
Stosic Dejan.

If you want the users to hide the first column set the ColumnWidth
property
of the combo box like this:

0;5

and set ColumnCount property as "2"


That means that the first column has zero width.





:

Hi,

I have a problem with combo box based on query that catches values from
two
tables. One of the columns is ID which value I need from combo box in
order
to take action after user pick up some choice in combo box.
When I open form (I have put default value 0 to combo box in order to
show
row in query with ID=0) combo box shows 0 in combo box. OK I need ID to
work
with, but I do not need user to see it. How to change this (combo box
should
show some other column from query different from ID, but take ID as
value
when selected)?

This is query that combo box relies to (works ok):
SELECT [qryDrzava_Grad].[IDgrada], [qryDrzava_Grad].[ImeGrada],
[qryDrzava_Grad].[PostBr], [qryDrzava_Grad].[Oblast],
[qryDrzava_Grad].[Drzava] FROM qryDrzava_Grad;

How to show for example [qryDrzava_Grad].[ImeGrada] instead of
[qryDrzava_Grad].[IDgrada] in the first column of combo box, but when
choice
is made to store value of [qryDrzava_Grad].[IDgrada]? Seems to me that
the
first column is the column that combo box picks values from. I do not
need
at all to show [qryDrzava_Grad].[IDgrada]. How to prevent column from
showing in combo box, but taking its value when choice is made?

Thank you in advance.

Best regards,
Stosic Dejan.