Option Group ListBox Row Source "Expected end of statement"

E

EiEiOhh

Joined
Sep 20, 2012
Messages
2
Reaction score
0
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


Code: 
SELECT tblPC.tblPCID, IIf(nz([tblPCMasterID]),"[COLOR=Red]X[/COLOR]","") AS myLinked, tblPC.tblPCCustomerName FROM tblPC ORDER BY tblPC.tblPCCustomerName;
Am I missing something simple?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

issue with row source of listbox 1
iif expected end of statement 2
Expected end of Statement 2
MsgBox..Expected End of Statement 2
Listbox row source is query with a control as criteria 2
Option group and listbox 1
End of statement expected error 2
changing the syntax of an SQL Select statement to appease VBA 4

Top