var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am trying to use 'find' method i a recordset. Here is my code :
strSQL = "[A] = '" & rst1![A] & "'" _
& " And [B] = '" & rst1![B] & "'" _
& " And [C] = '" & rst1![C] & "'"
This gives me an error when I try to execute the code. However, when I only the one-criteria variable (e.g. A), it works. Then, I use 'filter' instead and it works fine. Does anyone know why 'find' does not work in this case ?
Have you tried to use the command FindRecord!?
Isn't find record only for DAO ? I am using ADO. The filter works fine for me, it can do the job, I am just curious why by putting several variables in the strSQL, the find does not work.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors