Open another form from a subform...

[June7]

If you want to provide db with attempted code, follow instructions at bottom of my post.

[DaveWms]

This is the final code I used to get it to work:

Dim stDocName As String
Dim lngSelRecord As Long

lngSelRecord = [Forms]![Customers]![Invoices Subform]![InvoiceID]
stDocName = "Invoices"
DoCmd.OpenForm stDocName, , , "[InvoiceID] = " & lngSelRecord

Thanks for bearing with me through this.