record source problem

[tyrant]

no i'm sick of this
i spent whole afternoon searching the web and this forum for my answer
which i had and would have it but that jerk had to format the memory stick
grrrrrrrrrrrrrrrrrrrrrrrrrr

so here is the problem after a long brake of doing nothing i decided to make db app
now i remeber that i once found on the web something like this

adodc1.recordsource = "select * from and i do not know the rest
i found on this forum some topics with similiar code but it doesn't work and it is always .Open not .recordsource

i'm not some expert i'm just a kid (15 yrs) and really bad amateur
i want to find recordset in db using string in lets say Text1.text

by using code i found on the forum i would end up with this stupid err

Syntax error in FROM clouse

the code i'm using

Adodc1.RecordSource = "select ime " & _
                        "from baza where " & _
                        "ime= '" + Text4.Text + "'"
Adodc1.Refresh