[Forms]![Form1]! criteria .. performance crawls

[santa12345]

hello. i've been using a vb script that uses an access table, queries a cloudera linked table and returns the results.
ie.. access table could have some member ids, loops thru the table, one record at a time, returns the result, exports to excel and off to the next record, etc..
now the source table resides in vnext (sql). the vb script runs but is very very slow.
it has something to do with the criteria i have in the query itself. its identical as i had for cloudera ( [forms!][form1]![field_name]
if i remove the criteria and manual enter the criteria (member number), the query executes and i see the results in 20 seconds.
again, the vb runs but is very slow.
any suggestions would be much appreciated. Thank you.

 

[santa12345]

actually now... the [Forms]![Form1]![txt_agree] criteria does not return any data even thou the criteria entered in the form is valid.
is this a format data type issue?