Where Condition in Embedded Macro

[iuianj07]

Hello Guys!

I have a form (form1) that I need to put a button that opens another form (form2) Form1 and Form2 have LoanNumber and TestPeriod fields, and I want that when I click the button to open Form2, it will only show records if the LoanNumber and TestPeriod in Form2 matches Form1.

I used an Embedded Macro for the button, then OpenForm.

In the Where Condition field, I wrote ="[LoanNumber]=" & [LoanNumber] for it to show records to match LoanNumbers.

My question would be is it needs to have 2 conditions, that it should have LoanNumber and TestPeriod equal to Form1.

Thank you, any help is greatly appreciated.

 

[PHV]

Something like this ?
="[LoanNumber]=" & [LoanNumber] & " AND [TestPeriod]=" & [TestPeriod]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[iuianj07]

Hello PHV

I tried the code you gave me, and it had an error see below:

Syntax error(missing operator) in query expression '[LoanNumber]=502855937 AND [TestPeriod]=2010Q1'.

Do you happen to know what the missing operator is?

Thanks!

 

[PHV]

="[LoanNumber]=" & [LoanNumber] & " AND [TestPeriod]=[!]'[/!]" & [TestPeriod] [!]& "'"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[iuianj07]

Thanks! it's working now!

 

[iuianj07]

Hello PHV,

Thanks again for helping me out re-writing the Where Condition.

Could you spare a moment of your time and explain to me the above mentioned where clause? especially with all those missing operators and " ' & symbols.

Thank you and I appreciate it ;-)