Combobox error trying to attemp to build a cascading combobox from query form.

[warren0127]

I followed many examples and still get an error. When I go to make a selection from a second dropdown box, its giving me the following error:



"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables".

My original form was created from a query because I am going to use these subforms in a tabbed form. I tried to follow many examples of building cascading combo boxes.


I have a Customer Organization, Sub Organization, and Third sub organization tables (right now - I am only using the first two). I am trying to get it to where the second combo box only displays the suborganizations from the original first Customer Organization combo box.

In the Suborganization combobox properties, I opened up the the Row Source button to build a query statement. I added the Sub organization table. I included the "Customer Organization" field from the suborg table, and I included the "Sub organization" field from the suborg table. Under the Customer Organization field, I put a "where" in the totals column. My expression I used was [Forms]![frmMain]![cmbCustomerOrg] similar to an example found in another thread. I've also tried doing it a harder way through a video I followed and still had the same issue..

Please let me know what I am doing incorrectly here. I've attached a screenshot of the Query Builder under the "Sub organization" combobox.

EDIT: I have tried to follow even basic examples. Perhaps it is because I am not establishing my relationships as PKs/FKs? The tables I am using have lookups in each. For example, in the suborg table, I have all suborgs, and created a lookup to the main org table so each main org displays next to the sub org.

Thank you,
- Warren

[warren0127]

Also - for the row source expression in the suborg combobox properties box, its showing the following:

SELECT CustomerSubOrg.SubOrg FROM Customers INNER JOIN CustomerSubOrg ON Customers.CustomerID = CustomerSubOrg.CustomerOrg WHERE (((CustomerSubOrg.CustomerOrg)=[Forms]![frmTransitionQuery].[cmbCustomer]));


I have also attached the key relationships between the three tables - I had to create them as lookups in SharePoint because Access wont let you use the lookup wizard if you have linked tables. See attached - thanks!