to few paramiters

I keep getting an error  message " to few paramiters  Expected 1"  This error pops
up when I activate a button to open a form. I have no idea where this is comming from??
BillxxxxAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
This form was working for 10 years
And you've made no changes to the form, or to any queries, or anything like that?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Can you show the SQL for the RecordSource for the Form?
0
 
BillxxxxAuthor Commented:
this is from the form i am trying to open.


TRANSFORM Sum(Invoice.[Balance Du]) AS [SumOfBalance Du] SELECT Invoice.COMPANY, DSI_cust.WORKPHONE, DSI_cust.Test, Sum(Invoice.[Balance Du]) AS [SumOfBalance Du1] FROM DSI_cust INNER JOIN Invoice ON DSI_cust.COMPANY = Invoice.COMPANY WHERE (((Invoice.COMPANY)<>"Door Services, Inc (Presque)") AND ((Invoice.[Balance Du])<>0)) GROUP BY Invoice.COMPANY, DSI_cust.WORKPHONE, DSI_cust.COMPANY, DSI_cust.Test ORDER BY Invoice.COMPANY PIVOT Partition(Now()-[Invdate],1,90,30);

Thanks for helping. This form was working for 10 years
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
OK .... double check that to be *sure* there are no typos in any Field names.

This looks suspicious:

[Balance Du]) ?  In a couple of places  

Now ... are they any Combo/List boxes with RowSources?
0
All Courses

From novice to tech pro — start learning today.