qbf problem

A

alavaz17

I am trying to modify a database in Access 2002. The database was originally
created in Access 2000, and works fine there. But when I try to run the qbf
in Access 2002, I get a RunTime error 3075: Syntax error(missing operator) in
query expression '(())'
Here is the code with the error:

Function glrQBF_DoHide(frm As Form)
Dim varSQL As Variant
Dim strParentForm As String

'Get the name of the Parent form
strParentForm = left(CStr(frm.Name), Len(CStr(frm.Name)) - 4)
'Create the approprite Where clause based on the fields with data in them
varSQL = glrDoQBF(CStr(frm.Name), False)
'Open the Parent form filtered with the Where clause genereated above

DoCmd.OpenForm strParentForm, acNormal, , varSQL **This is the
error""
'Make this *_QBF form invisible
frm.Visible = False

End Function

Any help available?
Thanks in advance, Vicki
 
Top