"OrderID=" & Me.OrderID not working

[awcem]

I am working with Microsoft access 2003
i have a continuous form which shows summary date for purchase orders. This form is based on a query which looks at the Purchase Orders table and the Purchase Orders detail table
One of the fields in this contiuous form is the Order ID. When a user clicks on the order ID, i want them to see the full details for that order ID, based onthe "purchaseOrdersView" form
I have the following code

Private Sub OrderID_DblClick(Cancel As Integer)
On Error GoTo Errorhandling
 
    DoCmd.OpenForm "PurchOrdersView", , , "OrderID=" & Me.OrderID
 
 
GetOut:
    Exit Sub
Errorhandling:
    strMsg = "Error No. " & Err.Number & vbCrLf & "in Object: " & _
    Me.Name & vbCrLf & "Sub: OrderID_DblClick" & vbCrLf & vbCrLf
    MsgBox strMsg & "Standard Description: " & vbCrLf & Err.Description
    Resume GetOut
End Sub

However, when i click on OrderID, i am taken to the last record, not to the one i have clicked on....any thoughts

[Denburt]

It looks o.k. but I would use the following syntax:

DoCmd.OpenForm "PurchOrdersView", , , "OrderID=" & Me!OrderID

[missinglinq]

Is OrderID text or numerical? If text then

DoCmd.OpenForm "PurchOrdersView", , , "OrderID=" & Me.OrderID

should be

DoCmd.OpenForm "PurchOrdersView", , , "[OrderID]='" & Me.OrderID & "'" 

[awcem]

Is OrderID text or numerical? If text then

DoCmd.OpenForm "PurchOrdersView", , , "OrderID=" & Me.OrderID

should be

DoCmd.OpenForm "PurchOrdersView", , , "[OrderID]='" & Me.OrderID & "'" 

orderID is numerical - i tried your suggestion just in case but i get error message 205...any other ideas ? i am not really a programmer as you can probably tell so really stuck on this

[NeoPa]

Is the control on the form called [OrderID] too? I suppose the field in the record is called [OrderID].
If they are both named the same then try to Debug.Print to show what's in it before the call.