Error 3075 Missing Operator in query expression

[aytee111]

You could also create a query as the record source and link to the tables (such as category) to get the missing fields.

[PinkLady50]

Thanks! I fixed all those problems and now when I try to run any of the reports I get this error message from when the ProblemID was incorrect and I don't know where it's coming from so I can fix it.

I added the StaffID, CategoryID and ProblemID to the detail of the report and turned Visible to No.
Wasn't sure if they needed to be on the actual report or in the field list.
I included a pic of the error message.

[PinkLady50]

I added the StaffID, CategoryID and ProblemID to the detail of the report and turned Visible to No and they are also now part of the Problem_Record tbl which I use for everything.

[aytee111]

Change the field name on the table to be without the space. Spaces are considered very bad naming convention anyway. That seemed to fix it for me. If it does pop up again, then fix it where it happens.

[PinkLady50]

I changed the ProblemID in all the tables. I recreated the Row Source queries. I don't know where this is pulling from. If your copy of the DB works can you send it back to me.

[aytee111]

My copy doesn't have the correct table layout. The ProblemID is also on problem_record table, change the name to match the problem table.

[aytee111]

Post your db.

[PinkLady50]

OK. Found IT!!! Last thing not working!! All the boxes are now able to show the list and I can mulitselect items. The reports for Staff, Category and Problem all run but are not returning any data. I am so close!!

I appreciate everyone's help as this is due to Senior Mgt on Monday to demo!

[aytee111]

Not sure if you are still asking for help? If so, post your db.

[PinkLady50]

Here is the latest version.

[aytee111]

You are filtering the report - change the WHERE to FilterName.

[PinkLady50]

Dim strWhere As String 'String to use as WhereCondition

Is this where I am suppose to change the Where or is it someplace else.

[aytee111]

Here:
DoCmd.OpenReport strDoc, acViewPreview, FilterName:=strWhere, OpenArgs:=strDescrip

[PinkLady50]

It Works!!!! Thank you so much for your help and patience!!!!!!
Happy Friday!!
Have a great weekend!

[aytee111]

Great! Hope Senior Management are impressed!