How to combine static values with dynamic ones in a combo box?

[Ladi]

Dear pros,

I would like to combine values in a combo box ideally with different
columns, the one to bind and the one to show.

Help appreciated.
Ladi

 

[OfficeDev18 via AccessMonster.com]

In the combo box's property sheet, simply make the Column Width property of
the "not-show" column as 0". Make sure, though, that the Column Count is 2,
and that you put the correct column number into the Bound Column property.

Sam

 

[Ladi]

In the combo box's property sheet, simply make the Column Width property
of
the "not-show" column as 0". Make sure, though, that the Column Count is
2,
and that you put the correct column number into the Bound Column property.

Sam

Hi Sam,

Thanks for the advise but that is not enough for me.
I need to bind dynamic values and mix them with static values wich I will
enter manually.

Ladi

 

[OfficeDev18 via AccessMonster.com]

Ladi,

Access allows either "Table/Query" (dynamically generated values) or "Value
List" (pre-entered values) for a combobox. Manually entering values on the
fly for the combobox is not allowed, unless you find some way to put those
values into a table before running the combobox's row source, and then
include that table in the row source itself. It is doable, but not very
easily.

If this what you need, I'll be happy to help you, if you copy and paste here
the combobox's row source.

Happy to help,

Sam

In the combo box's property sheet, simply make the Column Width property
of

[quoted text clipped - 3 lines]

Sam

Hi Sam,

Thanks for the advise but that is not enough for me.
I need to bind dynamic values and mix them with static values wich I will
enter manually.

Ladi

Dear pros,
[quoted text clipped - 3 lines]
Help appreciated.
Ladi