Combo Direct From Table

I want to create a combo box that links direct to a table, rather than going through a query. Then when you select the record from the list it updates a text field to show the memo field of which the selected reccord is related

Can any one help

I tried using a query to do it, however queries only ever allow a maximum of 255 charcacters in the fields
basically the code looked like this

cboAfterUpdate()

me.txtfield = me.cboselection.column(1) ' because the data was in the seccond column
end sub

but as you can guess this only allows 255 characters to come accross from the memo field