Open From From SubForm Help Needed

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
 
M

Marshall Barton

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
 
T

Terry

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
Click a subform field to open relevant form 5
Save value from subform to table 1
Open form by doubleclicking in subform-datasheet 2
display sum from subform to mainform 7
Form Subform Issue 2
Insert order line numbers automatically by code? 14
subform help needed please 2

Top