Can I create simulated form/subform where master is a continuous f

[EMan]

I need a continuous form users can search and scroll through results to
narrow down results (e.g., all orders by client X). When they find the record
they need, (e.g., the order, where orderID is a key), I want to show them
another form with the details of that order, including each line item
contained in it (also keyed on orderID). Right now I use one continuous form
where users double-click the record to open up a second form with subform.
Instead of this, I want the second form to scroll with the first form, so
users don't have to keep switching forms and double-clicking. I'm guessing
this is easy, but I'm a novice and can't find a way. TIA.

 

[EMan]

Oops - should have mentioned this is Access 2007.

 

[Mixer1]

Here's what I do. See if it applied. my knowledge is somewhat limited,
however. It works for me . . . and I had help with it from someone else.

I created one Parent form which is simply a containter for two subforms. The
one subform is a continuous form. It is linked to a second subform, which is
an individula form containing details on the item clicked in the continuous
form. Is this what you are after?

In my example, VisitorName is a text field that shows up in the Continuous
form and also the detail form

On Error GoTo EH
Me.Parent.frmMainSub2.Form.Filter = "VisitorName = '" & Me.[VisitorName]
& "'"
Me.Parent.frmMainSub2.Form.FilterOn = True
Exit Sub
EH:
If Err.Number = 2455 Then
Exit Sub
Else
MsgBox "Error " & Err.Number & ": " & Err.Description
End If
End Sub


The error handling was added because subform 1 opens first and starts
looking for subform2 before it opens.

If you don't want to display the same field in 2 as you have in one, just
make it hidden. Hope this helps. Not sure I can help further if it doesn't.
I just wanted to contribute something . . .because everyone here has been so
helpful to me!

 

[EMan]

Looks very promising; tx. I'll let you know if it works.
--
-EMan

Here's what I do. See if it applied. my knowledge is somewhat limited,
however. It works for me . . . and I had help with it from someone else.

I created one Parent form which is simply a containter for two subforms. The
one subform is a continuous form. It is linked to a second subform, which is
an individula form containing details on the item clicked in the continuous
form. Is this what you are after?

In my example, VisitorName is a text field that shows up in the Continuous
form and also the detail form

On Error GoTo EH
Me.Parent.frmMainSub2.Form.Filter = "VisitorName = '" & Me.[VisitorName]
& "'"
Me.Parent.frmMainSub2.Form.FilterOn = True
Exit Sub
EH:
If Err.Number = 2455 Then
Exit Sub
Else
MsgBox "Error " & Err.Number & ": " & Err.Description
End If
End Sub


The error handling was added because subform 1 opens first and starts
looking for subform2 before it opens.

If you don't want to display the same field in 2 as you have in one, just
make it hidden. Hope this helps. Not sure I can help further if it doesn't.
I just wanted to contribute something . . .because everyone here has been so
helpful to me!

I need a continuous form users can search and scroll through results to
narrow down results (e.g., all orders by client X). When they find the record
they need, (e.g., the order, where orderID is a key), I want to show them
another form with the details of that order, including each line item
contained in it (also keyed on orderID). Right now I use one continuous form
where users double-click the record to open up a second form with subform.
Instead of this, I want the second form to scroll with the first form, so
users don't have to keep switching forms and double-clicking. I'm guessing
this is easy, but I'm a novice and can't find a way. TIA.

 

[Mixer1]

BTW, I put that code in the ON Current of the first subfom, the continuous one