open form action canceled

[noks]

I'm trying to open another form using a criteria. When i use 1 criteria all's well but when i use 2 the form doesn't wanna open. I get the following error msg

The open from action was cancelled

Here's my code:

stLinkCriteria = "([Customercode] = '" & Me![CombCustCode] & "' AND [unique_id] = '" & Me![combunique_ID] & "')"
MsgBox "[" & stlinkcriretia & "]"

Please kindly advise as i've ran out of ways of getting around this

Noks

 

[MStef]

Try this;
stLinkCriteria = "[CustomerCode] = [Forms]![FormName]![FieldName] And [unique_id] = [Forms]![FormName]![FieldName]"

 

[noks]

Thank you

It actually worked when u sed this code

stLinkCriteria = "[Customercode] = '" & Me![CombCustCode] & "' And [unique_id] = " & Me![combunique_ID]
it turns out it's coz the unique number is not text i had to take out the quotes