Invalid Column name

[kayclink]

hi, i am trying to generate a report through a record in a combo box but i get this error "invalid column name "DFG55FS"
Please note "DFG55FS" is a record name in my combobox. please help
i am using vb.net 2005 and SQL 2000

my code here..


"select *from Booking2 where horsereg =" & Me.ComboBox1.Te xt

[MikeTheBike]

Hi

Perhapse

"select * from Booking2 where horsereg = '" & Me.ComboBox1.Te xt & "'"

??

MTB

[kayclink]

thank you so much. it helped so sort out the problem...

[Max Payne]

thanks a lot..!!!! i wanted it for a search form very badly.. u solved my problem.. thanks again!!!