[AccessD] Where Condition in DoCmd.OpenReport

Ralf

In addition to Stuart's suggestion, I think the 'Me!' is also not correct.

I would try your Where Condition argument as:
"[AAA] Is Not Null"

Regards
Steve

-----Original Message----- 
From: Ralf Lister 
Sent: Saturday, October 15, 2011 2:07 PM 
To: 'Access Developers discussion and problem solving' 
Subject: [AccessD] Where Condition in DoCmd.OpenReport 

Hello,

I want to print a report whose recordsource is a query. This very query has
four records. One has in the field AAA a number stored. In the remaining
three records the field AAA is empty. I want to print the report only for
the record whose field AAA has a number stored.

Therefore I set the WhereCondition in the "DoCmd.OpenReport" command to
"IsNumeric(Me!AAA)". But it didn't work as expected. What did I do wrong?

TIA and Saludos
Actuary Ralf Lister
La Paz, Bolivia