Two List Boxes - Attempting to modify sample db - Multi Select list boxes as criteri

[CamL]

Hi,

I am trying to modify Jon K’s sample database, “Multi Select list boxes as criteria Access 2000”, but I am not having much luck.

I am attaching a database with my work
The main difference between the two databases:
I am using three tables: employers, customers and orders. The query is returning two fields from the orders table, one field from both the customers and employers table. There are two inner joins in the query. The two list boxes are searching on the employers and customers field.

Jon’s example uses two tables and has one inner join.

I have followed the code in Jon's sample db but I keep on getting an error in the code for the search button at qDef.SQL = SQL

Due to my lack of experience with Access and programming, I am at a lost as how I should go about getting this to work (if it can be done at all).

Any assistance is greatly appreciated!!

Cam

 

[CamL]

Hi everyone,

I had a colleauge looking at this as well and he solved the problem. I had everything correct just one comma too many in the SQL.
I have attached the corrected version in case anyone is interested.

Have a good day,
Cam