Problem with SQL statement

[dwadish]

Hai buddies i am razak .

dim strsql as string

strsql="select * from diary where da=#" & dtpicker1.value &"# and code=" & text1.text
set rs=db.openrecordset("strsql",dbopensnapshot)
if rs.bof and rs.eof then exit sub
text2.text=rs.fields(3)
rs.close

it have an error [ jet db strsql is nothing check the spelling etc]

i am already set the db source from form load()

here the "diary" is the table name


plz help me guys !!!

Thanx in advance..

[willakawill]

Hai buddies i am razak .

dim strsql as string

strsql="select * from diary where da=#" & dtpicker1.value &"# and code=" & text1.text
set rs=db.openrecordset("strsql",dbopensnapshot)
if rs.bof and rs.eof then exit sub
text2.text=rs.fields(3)
rs.close

it have an error [ jet db strsql is nothing check the spelling etc]

i am already set the db source from form load()

here the "diary" is the table name


plz help me guys !!!

Thanx in advance..

Hi. Happy Holidays :)

change this

set rs=db.openrecordset("strsql",dbopensnapshot)

to this

set rs=db.openrecordset(strsql,dbopensnapshot)

[dwadish]

Hi. Happy Holidays :)

change this

set rs=db.openrecordset("strsql",dbopensnapshot)

to this

set rs=db.openrecordset(strsql,dbopensnapshot)

thanx and it helped me to proceed

[willakawill]

thanx and it helped me to proceed

You are very welcome