find all values in a query

[andy49]

Ok try replace dim rs as recordset with dim rs as dao.recordset






Sent from my iPhone using Tapatalk

[Bulzie]

So you could have up to 6 IDLead values for each IDPaper or could it be more? And on your report, does it show all 6 text boxes but only shows data in the ones that have IDLead values? Maybe give us a sample of what your Report should look like with some sample data.

[boboivan]

@Andy49
I've made the replacement you've suggested and I still get Run-time error '3061': Too few parameters. Expected 1: line Set rs = db.OpenRecordset("TestQuery")

@Bulzie
Yes to all your questions. May be could be more than 6 IDLeads, but no more than 15. The report should look something like that:

[andy49]

Your "testquery" can't be called as it looks for a value idpaper Where is this value?


Sent from my iPhone using Tapatalk

[ssanfu]

The point is that in my table I have a field with multiple values (ex: John, Beth, Ruth).

The problem, IMO, is that you are using a multi-value field. If you change the design to a standard table design, what you are trying to do would be easier.
Try Googling "Multi value fields".

AFAIK, most Access programmers think "Multi-value fields", "Look-up fields and "Calculated fields" are not considered to be good programming practice.

[andy49]

DB11.zip

Is this any use?

[boboivan]

YES Andy!

This is what I need!

Thx a lot!