I tried to recreate your form, but i'm not getting any errors. Where are you
getting the error? The only thing that sticks out to me is you show this
If ok Then
found.Resize(, 6).Delete xlShiftUp
LoadData
Else
but don't show the code for LoadData

Signature
-John
Please rate when your question is answered to help us and others know what
is helpful.
It is not showing where i am having the error just that i just put that part
in so i assume it has to be in there.
Here is the load data code that works in my update code and lstbox click code.
Private Sub LoadData()
With lstData
.Clear
Ration = cboRation.Value
For Index = 2 To source.Rows.Count
If Ration = source.Cells(Index, 2) Then
.AddItem source.Cells(Index, 1) 'id
' .List(.ListCount - 1, 2) = source.Cells(index, eBoxes.Date1)
.List(.ListCount - 1, 2) = source.Cells(Index, eBoxes.Ingredient)
.List(.ListCount - 1, 3) = source.Cells(Index, eBoxes.Percent_of_ration)
' .List(.ListCount - 1, 5) = source.Cells(index, eBoxes.Ration_ID)
.List(.ListCount - 1, 4) = source.Cells(Index, eBoxes.Pounds)
End If
Next
End With
End Sub

Signature
Thank you,
Jennifer
> I tried to recreate your form, but i'm not getting any errors. Where are you
> getting the error? The only thing that sticks out to me is you show this
[quoted text clipped - 41 lines]
> > End If
> > End Sub
John Bundy - 30 Nov 2007 19:28 GMT
Sorry i really can't tell without seeing the sheet, someone here can i'm sure

Signature
-John
Please rate when your question is answered to help us and others know what
is helpful.
> It is not showing where i am having the error just that i just put that part
> in so i assume it has to be in there.
[quoted text clipped - 62 lines]
> > > End If
> > > End Sub
Jennifer - 30 Nov 2007 19:33 GMT
Thank you for your time i will keep at it. ;)

Signature
Thank you,
Jennifer
> Sorry i really can't tell without seeing the sheet, someone here can i'm sure
>
[quoted text clipped - 64 lines]
> > > > End If
> > > > End Sub