I've created a couple of form queries modeled directly after the examples in the book and I'm having troubles with text IDs.
I have three tables that query with numeric IDs just fine, but when I try to use a text ID, I get the following alert:
Can't find project or library
I click OK and see a yellow arrow pointing to:
"Private Sbu cboSelectOwner_AfterUpdate()"
and Chr$(34) is highlighted in grey.
When I use the toggle breakpoint button it highlights the line that Chr$(34) is on in dark red. Is there something wrong with the syntax here? I have it written as:
quote:strSearch = "[Organization] = " & Chr$(34) & Me![cboSelectOwner] & Chr$(34)