Can't Find Form erro (1 Viewer)

[schumarg]

Hi,

I have a form with a subform in it. I want to double-click one the the fields in the subform (PurchaseOrd) and have a tblPurchaseOrder2 form open to that particular record so I can edit a value in the record. (The value in the subform that I want to edit is based on an expression from a query, so I have to go back to the main table and edit one of the P/O's invoices.)

I have a double-click event on the field in the subform to open the PurchaseOrder2 form, and it does without a "Where" clause, but if I put a "Where" clause, then it can't find the form.

I've tried the following, but get suspect, I hope, that the syntax is not correct:

DoCmd.OpenForm "tblPurchaseOrder2", acNormal, , [Forms]![tblPurchaseOrder2]![PurchaseOrd] = [Forms]![tblPurchaseOrder subform]![PurchaseOrd]

Any suggestions would be greatly appreciated.

 

[Mile-O]

It needs to be a field that equals a value, and the criteria must be a string - you can, however, build this from actual values.


i.e.


"[MyField] = " & MyValue

 

[schumarg]

Thanks,

Getting there, it now opens to a blank record, not the record I need to edit.

Have the following now:

Private Sub Purchase_Order_DblClick(Cancel As Integer)

Dim PONum As String
PONum = [PurchaseOrd]
DoCmd.OpenForm "tblpurchaseorder2", acFormDS, , [PurchaseOrd] = "PONum"

End Sub

 

[Mile-O]

DoCmd.OpenForm "tblpurchaseorder2", acFormDS, , [PurchaseOrd] = "PONum"

DoCmd.OpenForm "tblpurchaseorder2", acFormDS, , "[PurchaseOrd] = " & PONum

 

[schumarg]

Hi,

Hate to be a pest, but.....

Now I get Run-time error '2501':

The OpenForm action was canceled.
Saying I clicked Cancel in a dialog box.