COMBOBOX problem (1 Viewer)

[maravinds]

Hallo Everyone,

I have a combobox with the following values in a from

Apple
Aircraft
Baby
Ball
Cat
Zebra
...
...
...

Moreover in this combobox i would like to type the letter "A" and after that i must be able to see options starting with A only.(Apple, Aircraft).

Is it possible via a combo box or is there any other way?

It will be helpful if anyone can say me the solution for this problem


Thanking you,

with regards,
aravind.s

 

[Smart]

I have a number of combo boxes each based on a query ot table

if i type a letter the first occurrence of any value with the letter appears in the combo box

(don't forget to sort your query)

 

[maravinds]

hai Smart,

sorry i cannot understand it completely. can you explain a little bit more detail.

aravind.s

 

[Smart]

RE:RE:COMBOBOX problem

Create a query that selects the data you would like to see in the combo box
(don't forget to sort the query)
create a combo box (using the wizard) and select the query you have just created.

open the form and click in the combo box type a letter and the first occurrence of an antry that starts with the letter you typed in will appear