Syntax error (missing operator)in query expression.

[cretanion]

Does this faq181-5497 work in Office 2003.

The Tag Where=Invoice Data Entry.Month is not working in my Listbox. I keep getting Syntax error (missing operator)in query expression.

 

[AlexCuse]

Invoice Data Entry" needs to be in brackets because the words are not joined by _

Try 'where [Value that you didn't specify] = [Invoice Data Entry].Month'

 

[cretanion]

I followed the directions in the FAQ181-5497

Simply add to the Tag Property Where=tblEmp.lngDeptID,Number;. That's all there is to it.

But you say to put in - where [Value that you didn't specify] = [Invoice Data Entry].Month

If I am using a Listbox isn't this the [Value that you didn't specify] when I make a choice?

I had to do the following to get it to work. Thanks for you help; Where=[Invoice Data Entry Monthly].Month,String;