Hi every one!
I have a main form where I want to open an other form on some given filter cirteria but it gives me "Type mismatch" error, after struggling for two days i am asking community for help, It will be greatly appreciated if some body can solve this.
The code is here below:
stLinkCriteria = stLinkCriteria = "[PCPNo]=" & "'" & Me![DN1] & "'" And "[SupplierCode]=" & "'" & Me![SelectedSup] & "'"
DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria
Note : Both the criteria fields are text
Thanking in anticipation
Sunny