Combo Box values

[Petros]

Hi all, i want to populate control A with the values from Column 1 and 2 from a Combobox..is this possible. Control A is the Combobox.

Thanks!

 

[vbaInet]

Welcome to AWF Petros

Is Control A bound or unbound?

 

[Petros]

Welcome to AWF Petros

Is Control A bound or unbound?

Control A is a bound control

 

[vbaInet]

Ok. You shouldn't save the value of existing data into another field. There's something called concatenating two fields which can be done in a query and you can use the concatenated field to display the result.

So for everytime you run the query it will display as Column 1 and Column 2 but without saving it. Get rid of the bound field in the table and use what the result of the concatenated value from the query as your control's control source.

Here's how you do it:

http://www.techonthenet.com/access/queries/concatenate.php

 

[Petros]

Ok. You shouldn't save the value of existing data into another field. There's something called concatenating two fields which can be done in a query and you can use the concatenated field to display the result.

So for everytime you run the query it will display as Column 1 and Column 2 but without saving it. Get rid of the bound field in the table and use what the result of the concatenated value from the query as your control's control source.

Here's how you do it:

http://www.techonthenet.com/access/queries/concatenate.php

Ok..I will change controll A to unbound...and on the "after update event" i will run the query...

 

[vbaInet]

You can change it in the query of the form. Create an aliased field (like in the example) and just use that field as the Control Source of Control A.

The field in the query would look like this:

ConcatValue: [Column1] & " " & [Column2]

Base your form on that query (which will include all the other fields, and use ConcatValue as the Control Source for Control A.

 

[Petros]

You can change it in the query of the form. Create an aliased field (like in the example) and just use that field as the Control Source of Control A.

The field in the query would look like this:

ConcatValue: [Column1] & " " & [Column2]

Base your form on that query (which will include all the other fields, and use ConcatValue as the Control Source for Control A.

Thanks a lot! i will proceed as suggested...

 

[vbaInet]

Goodie Let us know how you get on.

 

[Petros]

Goodie Let us know how you get on.

Nice indeed, once again, Thanks!

 

[vbaInet]

Glad you got that sorted

Remember: If you are calculating it, don't save it.