?
...
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.
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.