Re: Open From From SubForm Help Needed

From: Marshall Barton <marshbarton@xxxxxxxxxx>
Date: Tue, 23 Oct 2007 11:47:28 -0500

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

Follow-Ups:
- Re: Open From From SubForm Help Needed
  - From: Terry

References:
- Open From From SubForm Help Needed
  - From: Terry

Prev by Date: Re: Combobox filter default value before form open
Next by Date: String to Array
Previous by thread: Open From From SubForm Help Needed
Next by thread: Re: Open From From SubForm Help Needed
Index(es):
- Date
- Thread

Relevant Pages

Re: Open From From SubForm Help Needed
... (qryOrderStatus) ... that shows all a list of all open orders. ... able to double click on any row in this dataview and have the Order ... MVP ...
(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)