What am i doing wrong?
'baza = database
'naziv = title
'vsiartikli = table
'pregledtabela = MSFlexGrid

Private Sub Command1_Click()

baza.RecordSource = "SELECT naziv FROM [vsiartikli] where [naziv] like text1.text "
pregledTabela.Refresh
baza.Refresh

End Sub

hi! welcome to the forum!

it would also help if you had the subject of your post like
"sql syntax problem"

try changing your  sql statement into this:

baza.RecordSource = "SELECT naziv FROM [vsiartikli] where [naziv] like '" & text1.text & "' "

when you are using indirect values like --text1.text--, you have to exclude them from the quotes, and you also have to add the --'-- before and after, like that in the code.

hope this helps.
  

[Edited by vbgen on 05-01-2003 at 11:34 PM GMT]

____________________________
Been busy trying to take a second degree <--it's not working out...