Simple question - List in a combobox

  • Thread starter Thread starter Ilan
  • Start date Start date
I

Ilan

I want to limit the available values in a combo-box three values:
"Peter","Paul","Mary"

I have been playing around with two combobox properties: "Control source",
where I tried entering Peter, Paul and Mary using commas and semi colons,
without success, and by setting the "Row Source Type" property to "Value
List".

I think I tried every permutation, but have not been able to get a combo box
with three values of Peter, Paul, and Mary.

Guidance on this simple query appreciated.

Many thanks

Ilan
 
Ilan said:
I want to limit the available values in a combo-box three values:
"Peter","Paul","Mary"

I have been playing around with two combobox properties: "Control source",
where I tried entering Peter, Paul and Mary using commas and semi colons,
without success, and by setting the "Row Source Type" property to "Value
List".

I think I tried every permutation, but have not been able to get a combo box
with three values of Peter, Paul, and Mary.

Guidance on this simple query appreciated.

Many thanks

Ilan
Click to expand...


If you need only three values, and you don't need to dinamically change them
you can set the RowSourceType property of your combo to "List Value"
and put into RowSource property the simple string of values
"Peter;Paul;Mary"

Now when you open your combo you have the three chois....!

Really you can modify also by code all about, but i think is not
necessary....!

Sorry about my English mistakes.....!

Alessandro(IT)
 
Your English is fine.

I see where my problem was. I was listing my three properties in 'Control
source', whereas I should have been listing them in the property 'Row
Source'.

Thank you for helping me sort this out.

What is the difference between 'Control source' and 'Row source'?
 
Ilan said:
Your English is fine.

I see where my problem was. I was listing my three properties in 'Control
source', whereas I should have been listing them in the property 'Row
Source'.

Thank you for helping me sort this out.

What is the difference between 'Control source' and 'Row source'?
Click to expand...


When you have an associated Control(List/Combo) the Control Source property
it's
the Field associated to this one...!
The RowSource it's only the Data list that you need in your selection, after
selected
you PUT in associated field(ControlSource) the Value from RowSource
List....!

But the Online Help is really better then me....! ;-)

Good week end.
Alessandro(IT)
 
Back
Top