Hi there Roi
Thanx for your help.

Wel there's a problem with Marks' Class .. infact the combobox has a grudge againt me. It just refuses to work nicely. !

When I use Mark's class all goes fine bu when I add a new entry to the combo and if the current row is a newly appended record, either one of the items in the list of the combo gets replaced by the new value or a blank one appeares.

What to do !



>Hiten,
>
>Did you see my other post to you on this?
>
>The combo will only save what the user enters if it's in the list the the rowsource specifies. If they enter something that is not in the result set of you SQL it's no going to get saved.
>
>You need to add what the user entered to the underlying table the SQL draws from and requery.
>
>A much simpler alternative is to dl Mark M's combobox from the file area and use that. It's already done. Quit pulling your hair out. A 5 second download, and 5 minutes of looking at the class and your problem is solved.
>
>>Hello People.
>>
>>Has any one had such a problem.
>>
>>Here's my situation.
>>
>>In a table I have a remarks field of character type and width 30.
>>
>>In a form I use a ComboBox with type set to 0 - DropDown Combo
>>The rowsource is an sqlstatment which extract distinct remarks from the above mentioned table.
>>The rowsourcetype is set to sqlstatement
>>
>>The purpose of this is to help the user either select a already entered remark or to enter a new one.
>>
>>For some reasons the combo does not behave as it's supposed to.
>>
>>If i select a value from the combos' list it gets saved to the table but if i type in a new value a blank value is saved.
>>
>>Is this a known problem/feature of the combo box or am I missing something ?
>>
>>I desperately need to know the exact features of the combobox.
>>
>>Thanx