Input values are being inserted into source code on debug

H

Harry V

I have an Access 2003 form that takes input from a barcode scanner. Lately,
we've encountered barcodes that are outside of the design scenarois.on a
couple of these events, the program ends with an error (3021 EOF/BOF has been
reached). When I go into debug the value from the barcode scanner has been
enterd into the source code:
....
stSQL = stSQL & " AND ([Duplicate] = '" & stDupCode &
"');"
' Look for failed chems in bottle as paired - complete
or incomplete
rs5.Open stSQL, con, 1 ' 1 = adOpenKeyset
RW05 -18063
If (IsNull(rs5.Fields(0).Value)) Then
Set rs6 = CreateObject("ADODB.Recordset")
stSQL = "SELECT [FailedChems] FROM
[tblInboundICPtemp]"

....

"RW05-18063" is the value being searched for, it's being insereted on a new
line and the indentation for the following line is lost.

Has anyone encountered anything like this? Can I even write-protect the
source code within the form?
 
Top