goldstar1982
Registered User.
- Local time
- Today, 02:18
- Joined
- Jan 27, 2008
- Messages
- 10
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?
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?
