Please Help Me....

[Guest]

Dear Sir

1) I have Combo Box on the forms..row source type is vaule list..it has city
names of te world...now i want if user add new city name in the combo box it
shud be added in the combo and as well as next time if user comes to next
record ,,that vaule shud be added in the list..

2) IF Uses select the combo box..it show the list according to alphbatic
order..means if used select "f" it shud select all " f" alphbet words in the
combo box...

so please try to solve my two problems..

Thanking You

Husain Nagri

 

[Guest]

Coding will not be easy if you want to update this value list.
A different approach would be:
You should create a query using this field (city). Set the query properties
to Unique Values (right click in the top half of the QBE design for this) and
save this query (for example, qryCities). Now, set the Combo box's Row
Source Type to Table/Query and the row source to qryCities. Check that Limit
to List is set to No. As new cities are entered they will be added to this
list.

 

[Marshall Barton]

1) I have Combo Box on the forms..row source type is vaule list..it has city
names of te world...now i want if user add new city name in the combo box it
shud be added in the combo and as well as next time if user comes to next
record ,,that vaule shud be added in the list..

2) IF Uses select the combo box..it show the list according to alphbatic
order..means if used select "f" it shud select all " f" alphbet words in the
combo box...

You can not do those things in a reasonable way using a
value list. Create a table for the city names so you can
use a query for the combo box's row source. Then you can
use a little form to allow users to add more cities and the
query can easily sort the list.

 

[jahoobob via AccessMonster.com]

For 1, go here:
http://www.mvps.org/access/forms/frm0015.htm
For 2, I usually base combo boxes on a query where you can sort the column
you are going to view in the combo.