Hi All
I am trying to create a continuous form that the user can select the record they would like to view and when in this record print the details in report format. Is this possible
Thanks


Brendan Bartley

__________________
Brendan Bartley

Yes. How afar along are you?

I do this same thing using a continuous form where the user selects a second form based on the continuous form search function. This is the button code to open the next form:

'-----
    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmDetails"

    stLinkCriteria = "[DetailsID]=" & Me![DetailsID]
    DoCmd.Close
    DoCmd.OpenForm stDocName, , , stLinkCriteria
'-----

Alternatively, you could run a report using the link.
There is a button on each detail section of the continuous form. This works well for me.

Does this help?

mmcdonal