query aborted after first row (1 Viewer)

spikepl

Eledittingent Beliped
Local time
Today, 04:17
Joined
Nov 3, 2010
Messages
6,142
Since

NOT A AND NOT B

is logically equivalent to

NOT (A OR B)

you'd be better off (and that would obviate the need for any special NULL handling) by:

" WHERE NOT (Keyword1='" & ComboBox1.Text & "' OR Keyword2 = '" & ComboBox2.Text & '" .........
 

Users who are viewing this thread

Top Bottom