S
SuzyQ
I have an invoice form which has a line item subform. The line item subform
has a subform which is a list of all of the line items of the invoice form.
So...
frmInvoice has subform frmInvoiceLineAddSubform (in form view) based on
invoiceID
frmInvoiceLineAddSubform has a subform frmInvoiceLineItemListSubSub (in
datasheet view) based on InvoiceID
If the user selects an item in the list from frmInvoiceLineItemListSubSub, I
want to change the record on frmInvoiceLineAddSubform base on LineItemID
I tried this which gives an error "You canceled the previous operation"
#2001 so I commented it out. How can I select a record in a parent form
based on the record selected in the child form?
Private Sub Form_Current()
' Dim rs As Object
' Set rs = Me.Parent.Recordset.Clone
' rs.FindFirst "[LineItemID] = " & Str(Me![LineItemID])
' Me.Parent.Bookmark = rs.Bookmark
End Sub
has a subform which is a list of all of the line items of the invoice form.
So...
frmInvoice has subform frmInvoiceLineAddSubform (in form view) based on
invoiceID
frmInvoiceLineAddSubform has a subform frmInvoiceLineItemListSubSub (in
datasheet view) based on InvoiceID
If the user selects an item in the list from frmInvoiceLineItemListSubSub, I
want to change the record on frmInvoiceLineAddSubform base on LineItemID
I tried this which gives an error "You canceled the previous operation"
#2001 so I commented it out. How can I select a record in a parent form
based on the record selected in the child form?
Private Sub Form_Current()
' Dim rs As Object
' Set rs = Me.Parent.Recordset.Clone
' rs.FindFirst "[LineItemID] = " & Str(Me![LineItemID])
' Me.Parent.Bookmark = rs.Bookmark
End Sub