Error 3075 Missing Operator in query expression

[PinkLady50]

I spoke to soon. It is working somewhat! It is grabbing all records in the database not the ones selected by the listbox. All three are the same way now.

[aytee111]

Look at the data on problem_record table, the fields on my copy of the db are empty. I made a quick update query to update the categoryID and now it works.

[PinkLady50]

My db has about 10 records. I recreated the Category query on the lstCategory data properties but that didn't seem to change anything. Is there another place I need to update a query?

[aytee111]

Type the values in manually! Just get them in to the table.

[PinkLady50]

Should I be setting the Lookup on the Category field on the Problem_Record tbl. I have it now set to Listbox Table/Query; Category.

[PinkLady50]

Got it ! Those records were missing ID information

[PinkLady50]

I updated the table

[aytee111]

Don't mess with tables, no lookups, no formatting, nothing. Leave them simple. Anything else you need can be done in other places in the database. That always comes back and bites you. Set up links in the Relationships window.

[PinkLady50]

updates Relationships. Made sure the Problem_Record tbl has a StaffID, ProblemID and CategoryID for each of the records out there.

I recreated the query for Staff on the lstCategory but it is still pulling all data.

[PinkLady50]

Ta Dah!!!!! It's working!!!!!

Many thanks!!!

[aytee111]

Well done!