I'm missing something through lack of knowledge

[Sam Summers]

Ok, I sorted the syntax error with this:

stLinkCriteria = "[Area]='" & Me.[SelectArea] & "' And [ReportNumber]= '" & Me.[ReportNo] & "' "

but now I am back to the error message attached?

 

[Minty]

Okay that is quite easy.
Just set the default values on those controls on the subform to = the main Forms controls eg; On your Area drop down in the form design - Default value

=[Forms]![Main]![SelectArea]

 

[Minty]

So remove the Area bit from your criteria and just leave the report no bit and see post #22 for the solution.

 

[Sam Summers]

Wow!!!

Did that and that's it!!!

I knew it couldn't be that hard.

I will use that for the other options I need to create.

It was probably because I hadn't explained the problem clearly enough?

Many thanks for all the help.

On to the next problem now