Report from Record

[Egg 'n' Bacon]

A bit stuck with this one, and I'm not at all clear where I've made mistakes.

I'm trying to use a button (against individual record) to ope a report, with only the records for the 'main' ID. But I keep getting a data mismatch error, yet the data is from the same source

I've attached a stripped down version of the db & the button to the right of the records (on the form) is the one that's giving me grief.

[HansV]

In the first place, PersID is a number field, so you don't need quotes in the form of Chr(34) around the value - that is only needed for text fields:

DoCmd.OpenReport ReportName:="rptPersonSkillsGAP-FromForm", View:=acViewPreview, WhereCondition:="PersID=" & Me.PersID

In the second place, the record source of the subreport srptPersGap is based on qryPersGAP1 and qryPersGAP2. Both refer directly or indirectly to [forms]![frmPerson]![PersID] but there is no form frmPerson. Since you already use PersID to link the subreports to the main report, you should remove the condition

Like [forms]![frmPerson]![PersID]

from qryPersGap1 and qryPersGap3 (it's also in qryPersWantGAP but that isn't used elsewhere).

With these changes, it should work.

[Egg 'n' Bacon]

Cheers

That's done the trick