Open Report Code Issue

Topic

New Reply

I am trying to write the code that will open a report and make one field in the supporting query Not Null and another field Null.

Below is my attempt that does not work. Can someone help?

DoCmd.OpenReport “rptApplicationDataAll”, acViewPreview, , “Applydate Is Not Null” And “Appwithdrawal is Null”

Thanks.

Paul

Reply | Quote

Replies

Paul,

two aspects. First may just be a matter of finding the right words. Do you really mean that you want to set values in a query, or are you trying to limit the records shown on the report, by applying criteria? I’ll assume the latter.

So, If you are trying to apply a Where clause to the report, then you need an extra comma before your clause. It’s currently in the named filter position.

Then, you need to get the syntax right. Easiest way is to prepare a Select query using the normal query designer, then copy the part of the SQL Statement that you need. In this case, it is more likely to look something like “([Applydate] Is Not Null) And ([Appwithdrawal] Is Null)”. You will of course need both fields in the recordsource of the report, even if they are not shown in the printed report.

Hope this helps put you on the right track.

Regards,

Jules

Reply | Quote

Thanks. Your code worked.

Paul

Reply | Quote