Where Condition in Embedded Macros (1 Viewer)

[Dhamdard]

Dear all,

I spent 4 hours to find the error that causes an embedded macro not to work. When I open the attached database, I click on one of the question codes to open another from that shows me more details for the same question code. It doesn't work as far as I could understand.

Can you share your expertise and fix the problem in the attached database.
Thanks for your expert advice!

Thanks,
Dad

 

[Dhamdard]

When I click on the blue color question-codes, another form that has details for that particular question code should appear. But it doesn't work. I have used this expression in 'where condition' of the macro:
[expression]
="[QuestionCodeInDes]=" & [QuestionCodeInRes]

[Expression]

Above Macro expression has been added to on-click event of 'QuestionCodeInRes' field in Frm_Response form. On click, it should open Frm_ResponseDescription form with only those records that have the same question code that was clicked in the Frm_Response form.

Your help will highly be appreciated.

Thanks,
Dad

 

[Dhamdard]

Found the issue. The issue was how to surround the expression in the 'where condition' part of the macro so that the macro considers the field as a text. Here is how the expression should look like if the linking fields are text.

Where Condition: ="[QuestionCodeInRes]=" & "'" & [QuestionCodeInRes] & "'"

Can I think myself?

 

[Dhamdard]

I mean how can I THANK myself?