Link to multiple records in tabbed pages

[RORS002]

I would like to know how to link fields to multiple records without using a subform in tabbed pages. I've attached an example of what I'm working on. Basically, I have a set of the same values: Service Type, Acount #, Next Service Date, etc...but I have multiple locations with multiple services. (I want to see that Location A has Bottled Water services, Courier services, etc.) in the format exampled. Is there a formula I can put in the ID field to show all services for the one location? Any help is appreciated!

 

[wiklendt]

you could feed the ID to a query or a report on the click of a button.

something like:

Private Sub cmdPrintRLBsetup_Click()
On Error GoTo Err_cmdPrintRLBsetup_Click

    Dim strDocName As String
    Dim strCriteria As String

    strDocName = "rptRLBsetup"
    strCriteria = "[RLBID]= " & Me!RLBID
    
    DoCmd.OpenReport strDocName, acViewPreview, , strCriteria, acDialog


Exit_cmdPrintRLBsetup_Click:
    Exit Sub

Err_cmdPrintRLBsetup_Click:
    MsgBox Err.Description
    Resume Exit_cmdPrintRLBsetup_Click
    
End Sub

though i think you're using continuous forms there? i'm not sure whether this code will work in a continuous form situation (continuous forms are notorious for being tricky that way).