Cita: Select Case NxSearch
Case "all"
NxSQL ="SELECT * FROM ipfichaprod ORDER By id_ficha"
Case "T"
NxSQL ="SELECT * FROM ipfichaprod WHERE estado = "terminada" ORDER By id_ficha"
Case "P"
NxSQL ="SELECT * FROM ipfichaprod WHERE estado = "pendiente" ORDER By id_ficha"
Case Else
NxSQL ="SELECT * FROM ipfichaprod WHERE asistente = '"&NxSearch&"' ORDER By id_ficha"
End Select
Ya checaste tus comillas...???
, mas bien tu cadena que dice where... irían comillas simples no dobles..
Prueba con esto
Cita: Select Case NxSearch
Case "all"
NxSQL ="SELECT * FROM ipfichaprod ORDER By id_ficha"
Case "T"
NxSQL ="SELECT * FROM ipfichaprod WHERE estado = 'terminada' ORDER By id_ficha"
Case "P"
NxSQL ="SELECT * FROM ipfichaprod WHERE estado = 'pendiente' ORDER By id_ficha"
Case Else
NxSQL ="SELECT * FROM ipfichaprod WHERE asistente = '"&NxSearch&"' ORDER By id_ficha"
End Select
Suerte
