If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I create simulated form/subform where master is a continuous f
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 |
#2
|
|||
|
|||
Can I create simulated form/subform where master is a continuous f
Oops - should have mentioned this is Access 2007.
-- -EMan "EMan" wrote: 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 |
#3
|
|||
|
|||
Can I create simulated form/subform where master is a continuous f
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" wrote: 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 |
#4
|
|||
|
|||
Can I create simulated form/subform where master is a continuo
Looks very promising; tx. I'll let you know if it works.
-- -EMan "Mixer1" wrote: 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" wrote: 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 |
#5
|
|||
|
|||
Can I create simulated form/subform where master is a continuo
BTW, I put that code in the ON Current of the first subfom, the continuous one
"EMan" wrote: Oops - should have mentioned this is Access 2007. -- -EMan "EMan" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|