Open From From SubForm Help Needed

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I have a sub form (subfrmOrderStatus) that has a data source of a query
(qryOrderStatus) that shows all a list of all open orders. I want to be
able to double click on any row in this dataview and have the Order
Form(frmOrders) open up to show the specific order number that I just
clicked on.

Can anyone guide me in the right direction on how to accomplish this?

Thanks

Terry
 
Terry said:
I have a sub form (subfrmOrderStatus) that has a data source of a query
(qryOrderStatus) that shows all a list of all open orders. I want to be
able to double click on any row in this dataview and have the Order
Form(frmOrders) open up to show the specific order number that I just
clicked on.
Click to expand...


In the double click event, use something like:

DoCmd.OpenForm "frmOrders", , , "OrderID=" & Me.OrderID
 
Thank you. This worked just fine.

Terry

Marshall Barton said:
In the double click event, use something like:

DoCmd.OpenForm "frmOrders", , , "OrderID=" & Me.OrderID
Click to expand...
 
Back
Top