Stuart McLachlan
stuart at lexacorp.com.pg
Thu Mar 4 17:27:37 CST 2004
On 4 Mar 2004 at 7:28, Hollis,Virginia wrote: > Still struggling... > > On the recordsource for the combo box I put: > SELECT tbl_NCSA.NCSAID, tbl_NCSA.NCSANo FROM tbl_NCSA; UNION SELECT "*", > "All" FROM tbl_NCSA; > This gets me the word ALL in the list. > > Then on the AfterUpdate of cboNCSANo, I put (this gives me a type mismatch > when I select All): > If Me![cboNCSANo] = "All" Then > DoCmd.ShowAllRecords > Else > DoCmd.ApplyFilter , "[NCSAID] = " & str(Me![cboNCSANo]) > End If > Looks like NCSAID is numeric. In which case you can't use a character "*" in the second part of the Union. Use something like -1 instead. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.