Pass VB variable to query criteria? 1

[dmon000]

How can you get a VB variable value as the criterion in a query?

 

[orna]

In the criteria call a function that returns the variable.

 

[jadoogar]

You construct a string in which the query you want to pass to SQL/Access like this

command = "insert into village_facilities values ('" & mdate & "','" & x2 & "','" & x3 & "','" & x4 & "')"

where x1, x2 are values to be passed
'" & varname & "' will pass a non numeric value where as
" & varname & " will pass a numeric value

to execute the query use
conn.execute command
where conn has to be defined to the database.