Display value of table field in unbounded text filed on form

[ezybusy]

Hi everyone,


I have designed a entry form which has a combo box that shows a list of products.
Now what i want to do is "place an unbounded text box that will automatically display the details of the product that the user selects from the combo box".
Any help please!!!

[ranman256]

in the combo box have extra columns that contain the details.
the combo query will have 2 columns, the NAME, DETAILS
set properties:
cboProd.columns = 2
cboProd.colwidths = 1;0 (so you dont see the details)

then after user selects the item, fill in the text box from the column

sub cboProd_afterupdate()
   txtDetails = cboProd.column(1)     'remember columns start with 0, so the 2nd col = 1
end sub