add data from listbox to textboxes

[sireesha]

In access 2007, I have a form with listbox. listbox is connected to query. in the listbox 4 fields of data is shown. when i select listbox row, click on button those 4 fields data is displayed in textboxes. i assigned listbox.column(0) to textbox1, listbox.column(1) to textbox2 and so on. but it gives error recordset is not updateble. why. Please give me help

[alansidman]

Look here

http://www.baldyweb.com/Autofill.htm

Alan

[Robeen]

Can you give us the exact steps you are taking before you get your error?
When I see 'recordset is not updateable' - I think you are trying to update a query.

[Robeen]

Sorry Alan . . . didn't see your post when i posted mine.