>>>Hi! The combobox becomes slow when used to with a file containinga large no. of records and the general suggestion in this caseis to use a textbox in combination with a grid control. However whenentering data e.g. a product in to a order entry form the combo boxis bound to order_detail.product_code field and displays / allowsentry of the product_name. How can something similiar be achieved witha text and grid control, or what are the alternatives.Thanks in AdvanceSonali>Hi Sonali,>I never found combos as flexible as grids (my own point of view). In a textbox you get code and in interactivechange seek in grid. Combine it with a row highligthed grid class then it's like a combo being more than a combo. Grids with headerheight=0 and scrollbars=2 (vertical) would constitute the combo in its visual way and textbox's keypress, interactive change etc would handle the entry (and grid.visible = .f. at lostfocus). To make it more like a combo you could also add a commandbutton with a downarrow
>bmp on it placed just to the right of textbox (seems to be a new container class for me if I ever need it).>CetinThat may be so, but my point is that for data entry the controlsoure ofa combo box may set to say item.code while the user selects from item.nameHow can the same thing be achieved with a textbox and grid ?Sonali
Sonali,
In grid you could list itemnames from lookup, textbox controlsource will be target.itemcode and in grid afterrowcolchange you would simply change textbox value with grid.recordsource.itemcode. In texbox interactivechange you would do a seek on grid.
Cetin