Error with my subform

[gcommservices]

I am a tech trying to help a user decipher the error message he gets when clicking the + sign within his form. The error states that the expression is too complex to be evaluated. Can anyone point me in the right direction here? I don't know everything there is to know regarding Access, so please keep that in mind. I will post some things here that I think may help you see what's going on.



In the parent form called CIS Entry, the control source is Client ID#.

When you right click the + sign and select form properties, the record source says - SELECT [Referral].[Client ID#], [Referal].[Referal#], [Referal].[Docket#], [Referal].[Request for Service], [Referal].[Referal Source], [Referal].[Person Refering], [Referal].[Charges], [Referal].[Courtroom], [Referal].[Verdict], [Referal].[Probation Status], [Referal].[Probation Officer], [Referal].[Sentence Length], [Referal].[Suspended Length], [Referal].[Court Cost], [Referal].[Fine], [Referal].[Restitution], [Referal].[Time Out], [Referal].[TASC], [Referal].[Community Service], [Referal].[Day Reporting Center], [Referal].[Center Point], [Referal].[Stay away from victim], [Referal].[Case Status], [Referal].[Noncompliance], [Referal].[Reason not enrolled], [Referal].[Victim Name], [Referal].[Victim Phone], [Referal].[Referring County] FROM Referal;

Can you please tell me if this long list is why I'm getting the error? Thanks for your help!

[June7]

The statement is probably too long (exceeding 256 characters). Since the SQL is just the one table with no filtering or ordering, can set form RecordSource property simply to the table, no SQL statement needed. If must use an SQL statement, simply: SELECT * FROM Referal;

I am confused, what do you mean by 'right click the + sign and select form properties'? I thought the + link is to view a related record, I don't understand how form properties would be available.