John Clark
John.Clark at niagaracounty.com
Tue Apr 12 10:15:37 CDT 2005
I am so close! Here is a snippet from my code...there are six more cases: Select Case [Forms]![frmrpt_quarterly]![FrameChoices] Case 1 strChoice = "qryApril05-SenComp" lblGeneric.Caption = "Senior Companion" logGeneric_Label.Caption = "Sen Comp" Case 2 strChoice = "qryGeneric" lblGeneric.Caption = "EISEP" logGeneric_Label.Caption = "NFSC" If on the calling form has the first option chosen, I get an error that there is a "syntax error in the FROM clause", yet it runs fine with case 2. Are you not allowed to have the "-" character?