run append query using where clause

[tagteam]

Can you run an append query using a where clause



Like this but to run an append query

DoCmd.OpenReport "r_Shop1and7IndividualCoverSheet", acViewReport, , "[BillingInvoiceID] = '" & Me.BillingInvoiceID & "'"

[ranman256]

docmd.openquery "appendQry"

the where is in the query.... but use the full path
forms!myForm!BillingInvoiceID

[tagteam]

The problem is that I am using this from a continuous form, will it be able to pull that value when using a continuous form?

[ranman256]

it will pull the 1 current record your cursor is on.