Send value to parameter query

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

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

VB Code:

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

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

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

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