Combo box with database

Hi!

I'm trying some new fundas with VB 6.0 and database and fortunately, I found Tally (an Indian Software for Accounts). It has some worst interfaces i've seen but the good thing about it was it contains a combo box type thing in which when <Enter> is pressed the combo box drops down all items and moreover the user cannot select or enter anything beyond the items list of the CBO.
How this happens. Can anybody help me explain it?

Amit

I guess it is implemented that it uses the MS database object(like adodb object) to connect a database and get a table's fields name,at the end list the fields name into the combo box..

A question, Amit - does the combo box only display this behavior when the cursor is on it and you hit <Enter>, or does it do it anytime the form is active and you press <Enter>. If it does it anytime the form is active, then I would say that the program is looking for the <Enter> key in the form_Keypress event. As far as having the fields from the database, you can load them manually via a loop, or you can set the datasource for the combo box to the column (field) in the table you wish to use. The combo box can be made to behave like a list box (so that you cannot type new values) by setting the style = 2 in the properties window.

Hope this helps.

Hi,Fisherman.I huzza what u said..It's a fast way to implement bhandariamit_in's aim!...THX again!..