Hi all. I have incorporated search in my maintenance forms using the technique from the turorial 6. Upon running I get an error:



{"Invalid object name 'tlbBarelLength'."}



Code under my search button:



Me.BarrelLgtnBO1.FillByLength(Me.txtSearch.Text)



My BO code:





Public Sub FillTop100()

Me.FillDataTable("Select TOP 100 * FROM tblBarelLength")



End Sub





Public Sub FillByLength(ByVal BarrelLength As String)

'-- Estabish Locals

Dim loCommand As New SqlCommand



'-- Build the query

loCommand.CommandText = "SELECT * FROM tlbBarelLength WHERE Length = @length"



'-- Add the parameter

loCommand.Parameters.Add("@length", SqlDbType.VarChar)

loCommand.Parameters("@length").Value = BarrelLength



'-- Execute the command to fill the business object

Me.FillDataTable(loCommand)

End Sub



Now the if the FillTop100 code works which is calling the same table object why is the FillByLength code inop?



Lost In Ventura....



Regards,



Robert