>Hi Cetin:
>
>I implemented the code and it still gave me a syntax error. Below I have cut and pasted what is "exactly" in my combo.init(). Maybe you can see something in it I am missing.
>
>thisform.currentstate = ""
>lcSQL = "SELECT DISTINCT TOP 15 Voterfilefields.cfieldlabel, "+;
> "Voterfilefields.cfieldname, Voterfilefields.cfieldfilestate, "+;
> "Voterfilefields.nfieldid, Voterfilefields.cfieldcategories "+;
> "FROM voices!voterfilefields "+;
> "INNER JOIN voices!fielddetails "+;
> "ON Voterfilefields.nfieldid = Fielddetails.nfieldid "+;
> "WHERE Voterfilefields.cfieldcategories = "Identifier" "+;
> "AND Voterfilefields.cfieldfilestate = ?thisform.currentstate "+;
> "ORDER BY Voterfilefields.cfieldlabel "+;
> "into cursor Cursor5"
>this.rowsourcetype = 3
>this.rowsource = lcSQL
>
>
>TIA
>
>Jason
Jason,
Oooo. Quotes in quotes. Replace all " with ' except the ones surrounding "Identifier". Also change ?thisform.currentstate to thisform.currentstate.
Cetin