simple SQL syntax with hyperlink

[markjkubicki]

I'm getting a sytax error (which is prob blatently simple, but it's getting late....)

i've been able to isolate the problem to be the portion of the WHERE statement that deals with

the field BaseCatalogSheet which is a hyperlink
and the variable vBaseSheet is that is text

Dim sSQL As String
sSQL = "Delete from tbeAdditionalPages" & _


" WHERE [BaseCatalogSheet] = " & vBaseSheet & " and [Type] = '" & Me.Type.Value & "' ;"
CurrentDb().Execute sSQL, dbFailOnError

any thoughts would be a hughe help,
with thanks in advance,
Mark

[pbaldy]

I haven't used it, but I would think the hyperlink would act like text. Have you tried surrounding the value with single quotes like the other one?

[markjkubicki]

when I add the qoutes, i geta 'data type mismatch error'

Dim sSQL As String
sSQL = "Delete from tbeAdditionalPages" & _
" WHERE [BaseCatalogSheet] = '" & vBaseSheet & "' and [Type] = '" & Me.Type.Value & "' ;"

CurrentDb().Execute sSQL, dbFailOnError