>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.

Hi Hiten,

I haven't used Mark's class in a while, so hopefully he'll see this and help out. ... did you put your SQL in the mQuery method?

I think all you have to do is drop it on a form, put SQL in the mQuery, and fill out the controlsource and you should be done.