run time error 3078

[hfs]

can anybody see the problem with this code!??@
Run time error '3078'

The microsoft access database engine cannot find the input table or query 'false'.Make sure it exists and that its name is spelled correctly.

Set db = CurrentDb()
        Set ctl = Forms!frmVerifiedBy.Form!LotVerified
          
            If ctl = True Then
SQL = "update tblExcelLocation set LotVerifiedDate = Now, LotVerifiedBy = '" & Replace(str3, " '", "''") & "',' " & Comments = Replace(str4, "'", "''") & "'  WHERE LotVerified = true  And   ID = '" & Replace(str5, " '", "''") & "'"
             

 [COLOR="Red"]  CurrentDb.Execute SQL[/COLOR]
        
              
           Else

            
            MsgBox "Please select the checkbox "


         End If

 

[pbaldy]

This is the common method used to debug SQL in code:

http://www.baldyweb.com/ImmediateWindow.htm

If you don't spot the problem, post the SQL here. By the way, why create the db variable if you don't use it?

 

[pr2-eugin]

Have you tried something like Debugging using the Immediate window? http://www.baldyweb.com/ImmediateWindow.htm

 

[David R]

One of you guys needs to go to lunch, you're running over each other in your eagerness to help...

 

[CJ_London]

Plenty

where is the code located? in the frmVerifiedBy form?

is LotVerified in a subform?

Is ID a text or a number?

where do str3,4 & 5 come from?

 

[pbaldy]

One of you guys needs to go to lunch, you're running over each other in your eagerness to help...

LOL! It's probably pretty close to pub time in the UK. Only 9:30am here, so too early for lunch for me.

 

[pr2-eugin]

One of you guys needs to go to lunch, you're running over each other in your eagerness to help...

It's so cool that we also provide the similar link and suggestion.. Ha Ha. I am off in 20 mins..

 

[hfs]

thanks alot for ur guys help. i mean this is so cool when ever my mind is not working i just post a thread and go for a tea break ,problem get solved before i come back !!

Thanks alot and i always forget to write the debug.print line .....that worked

 

[pr2-eugin]

Just adding Debug.Print solved? WoW !

What was the problem if you don't mind me asking and how did you solve it?

 

[hfs]

OH actually,the problem was in my syntax


SQL = "update tblExcelLocation set LotVerifiedDate = Now, LotVerifiedBy = '" & Replace(str3, " '", "''") & "',' " & Comments = Replace(str4, "'", "''") & "' WHERE LotVerified = true And ID = '" & Replace(str5, " '", "''") & "'"


i had to add '" & after comments = ....
and remove the '" before comments !

and this was giving me the database error ,instead of giving me syntax error !

Thanks to u guys for showing me the right direction!

 

[hfs]

new statment and its working

SQL = "update tblExcelLocation set LotVerifiedDate = Now, LotVerifiedBy = '" & Replace(str3, " '", "''") & "', Comments ='" & Replace(str4, "'", "''") & "' WHERE LotVerified = true And ID = '" & Replace(str5, " '", "''") & "'"

 

[pbaldy]

Glad it helped you!