Opening a record set (not found in forum search) 3

[santastefano]

I get an error message against line "Set rsInvoiceCopy" etc.
"Too few parameters. Expected 1" with this code.

Dim rsInvoiceCopy As DAO.Recordset
    Set DB = CurrentDb
    Set rsInvoiceCopy = DB.OpenRecordset("qryCopyInvoice", dbopendynaset)
    rs.Open "InvoiceCopy"

I am having trouble understanding because I use the same code in about 15 other areas.
The query delivers the correct information when run in isolation.
Any suggestions - please

 

[TheAceMan1]

How are ya santastefano . . .

[blue]   Dim db as DAO.Recordset[/blue]

. . . as well.

See Ya! . . . . . .

 

[PHV]

Isn't qryCopyInvoice a parametized query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

Why define a variable you only use once?

Set rsInvoiceCopy = CurrentDB.OpenRecordset ...

 

[TheAceMan1]

santastefano . . .

woops! . . .

My post is incorrect . . . should be:

[blue]   Dim db as DAO.[purple][b]Database[/b][/purple][/blue]

See Ya! . . . . . .