Re: Open From From SubForm Help Needed

From: "Terry" <terryd@xxxxxxxxxxx>
Date: Tue, 23 Oct 2007 12:38:24 -0500

Thank you. This worked just fine.

Terry

"Marshall Barton" <marshbarton@xxxxxxxxxx> wrote in message
news:m89sh3h9gd8pmv9ret34diptmn0cuga8u3@xxxxxxxxxx

Terry wrote:

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.

In the double click event, use something like:

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

--
Marsh
MVP [MS Access]

References:
- Open From From SubForm Help Needed
  - From: Terry
- Re: Open From From SubForm Help Needed
  - From: Marshall Barton

Prev by Date: String to Array
Next by Date: Re: String to Array
Previous by thread: Re: Open From From SubForm Help Needed
Next by thread: String to Array
Index(es):
- Date
- Thread

Relevant Pages

Re: Open From From SubForm Help Needed
... Terry wrote: ... (qryOrderStatus) ... that shows all a list of all open orders. ... able to double click on any row in this dataview and have the Order ...
(microsoft.public.access.formscoding)
Open From From SubForm Help Needed
... I have a sub form that has a data source of a query ... (qryOrderStatus) ... that shows all a list of all open orders. ...
(microsoft.public.access.formscoding)