Query Help :copying rows

[pbaldy]

Weird, because I leave that space after the "=" all the time. Here's the end of a working piece of code:

strSQL = "...AND Division = " & Me.txtDivision

In any case, glad you got it sorted out.

 

[artificiality]

Not that fast...

I rerun the thing again.

And instead of 256 for id , I got 25. The id value is still what it should be : 256

Then I add or remove spaces and get the right query.

I run again the application and the query string gives me 25 again.

This is not deterministic.

And so on.

I am lost....