Send value to parameter query

[sbudhisatrio]

i'm using MS-Access database...and create alot of query inside. can i sent a value for parameter query from vb?

[Besoup]

You are better off creating your own SQL statement and using ADO.

[jethrobg]

dim rs as recordset
dim st as string
    st = "1" 'parameter options
    rs = mydb.openrecordset ("SELECT * FROM Table1 WHERE ID = " & ST)
   ......
    rs.close

hope it will help

[si_the_geek]

In the Database FAQ is an example, in the article "how can I add a record" (method 4).

[sbudhisatrio]

thanx to all of you...but for u "si_the_geek"...thanx again, that's what i mean. actually i have search from FAQ...but i can't i so many sub-description it have...and and don't think it put under "how can I add record"

but aniway...thanx alot

[si_the_geek]

It should be in a separate FAQ thread as well as being there - another one for my "to do" list!