Open Related Form When Click Field (1 Viewer)

[scouser]

Hi. I would like to open Form B when a field is clicked in Form A.

Form A = frmCustomerOrderHistory1 (OrderID)
Form B = frmSalesOrders

When user clicks OrderHistory (OrderID) I would like frmSalesOrders to open displaying the corresponding Order.

I have tried:

DoCmd.OpenForm frmSalesOrders, acNormal, [Forms]![frmCustomerOrderHistory1]![OrderID] = [Forms]![frmSalesOrders]![OrderID], , acFormEdit, acWindowNormal

Any help much appreciated.
Phil.

 

[Ranman256]

the 1st part of the where clause is the field,
the 2nd is the textbox on the form. no need for the full path, since you are already in the form.

DoCmd.OpenForm frmSalesOrders, acNormal, "[OrderID] = " & txtOrderID

 

[scouser]

OK, I have resolved.

DoCmd.OpenForm "frmSalesOrders", , , "OrderID = " & OrderID.Value

Phil.

 

[scouser]

Hi. Just seen your post, that was quick! I managed resolve in the meantime. Thanks.
Phil.

 

[CJ_London]

try

DoCmd.OpenForm "frmSalesOrders",,, "[OrderID] = " & [OrderID], , acFormEdit, acWindowNormal