Hello All,

Just had a query with my order system. Currently i have a orderline where you can select a itemid and the details appear, once add has been selected this transfers the data into the listbox.
If i want to edit a record, i want to double click on the record from the listbox and want this to appear within the orderline above so it could be edited. Any ideas on how i can this to appear from the listbox back to the the orderline. This is the code that i have tried.

Private Sub hireDetails_DblClick(Cancel As Integer)

Dim rstitem As DAO.Recordset
Dim stritemID As String

Set rstitem = dbase.OpenRecordset("tblloan", dbOpenDynaset)

stritemID = hireDetails.Value

rstitem.FindFirst ("[itemid] ='" & stritemID & "'")


txtitemdescription.Value = stritemID

End Sub

This brings up detail within itemdescription textbox, but not the right part of the record. the totalcost appears within there. any ideas?