I am trying to set a ListBox rowsouce via Option Group
I want to populate the first column (myLinked) with an X is tblPCMaterID is BLANK or NULL
The following works fine in the the control's Row source but I get a compile error expected end of statement at X
Am I missing something simple?
I want to populate the first column (myLinked) with an X is tblPCMaterID is BLANK or NULL
The following works fine in the the control's Row source but I get a compile error expected end of statement at X
Code:
SELECT tblPC.tblPCID, IIf(nz([tblPCMasterID]),"[COLOR=Red]X[/COLOR]","") AS myLinked, tblPC.tblPCCustomerName FROM tblPC ORDER BY tblPC.tblPCCustomerName;