Run-time error no. 2501

I gather from searching this and other forums that this is often a difficult error to pin down but maybe someone can help. I am opening a new form from a subform. The following works ok but means opening the whole recordset and moving to the one I want:
DoCmd.OpenForm "frmClientPODetail", OpenArgs:=Me.PONo
What I really want to do this:
DoCmd.OpenForm "frmClientPODetail", WhereCondition:="PONo = " & Me.PONo
but this give the error above. Debugging shows that the error is generated in executing the OpenForm line itself, not in trying to open the new form.

Any suggestions?

Bob

I suspect your PO Number is a text field so:
DoCmd.OpenForm "frmClientPODetail", WhereCondition:="PONo = '" & Me.PONo & "'"
...should work.


HTH RuralGuy (RG for short) acXP WinXP Pro

Thanks RG. Of course you're right, just because it's called a PO Number doesn't mean it really is a number!