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

Table name is misspelled in second fill method (FillByLength)





indicates you misspelled the table name.

I gotta tell you, the day started out with dumping coffee on my keyboard and it's been downhill since then.. um thanks Greg for spotting what I would have taken me all day to see..



Regards,



Robert

No problem...I've had a few of those kind of days myself. It's good to have the forum here to help us during those trying times! Hope you'll do the same for me some day!

You can count on it Greg, assuming I know the answer.. lol.



Robert

Greg, is a good man!

..ßen

I'm sure he is... Everyone here has been good to me.. helping me along even on weekends. When I get up to speed I'll do my best to help others. In the mean time... lol.



Robert