Text box instead of combobox

[jeff klein]

My frm_Orders record source is tbl_Orders.
On the frm_Orders I have a combobox that shows Item price - the combobox
control source is ItemID and the record source is SELECT DISTINCTROW
tbl_Items.ItemID, Item.Rate FROM tbl_Items. This shows the price of the item
in the orders form.

OK...what would be the way to show the same information in a text box
instead of the combobox?

 

[Mike Painter]

My frm_Orders record source is tbl_Orders.
On the frm_Orders I have a combobox that shows Item price - the
combobox control source is ItemID and the record source is SELECT
DISTINCTROW tbl_Items.ItemID, Item.Rate FROM tbl_Items. This shows
the price of the item in the orders form.

OK...what would be the way to show the same information in a text box
instead of the combobox?

Make the selection.
Loop through the records and create a string that would properly display in
the text box for that particular width (with scroll bars) and type size.
Plug it into the textbox.
Not difficult but time consuming.