Adrianna
Registered User.
- Local time
- Today, 03:08
- Joined
- Oct 16, 2000
- Messages
- 254
Okay...I don't know why this doesn't work and my presentation is first thing tomorrow morning.
I have an option group that allows the client to select a division for which they would like to narrow the reports down to. So, they select a division and when the report opens and their is matching data...everthing is fine.
When the are no matching records, the report opens up blank. I would just like for the report to say that there are no matching recrods. I tried this on the OPEN WHERE condition
=IIF([Forms]![ReportOptions]![SelectDivision] Is Null, MsgBox "There are NO records that match the division that you have selected", "[Division]=Forms![ReportOptions]![SelectDivision]")
But it did not work. I know that I'm probably over looking something, but my eyes just can't stare at this screen anymore today.
The following opens up the blank form, but it works....so how can I get the MsgBox to function properly?
=IIF([Forms]![ReportOptions]![SelectDivision] Is Null, "", "[Division]=Forms![ReportOptions]![SelectDivision]")
P.S. I have to stay within my Marco. I don'thave time to code all of the selections and print options
Thanks in advance!
I have an option group that allows the client to select a division for which they would like to narrow the reports down to. So, they select a division and when the report opens and their is matching data...everthing is fine.
When the are no matching records, the report opens up blank. I would just like for the report to say that there are no matching recrods. I tried this on the OPEN WHERE condition
=IIF([Forms]![ReportOptions]![SelectDivision] Is Null, MsgBox "There are NO records that match the division that you have selected", "[Division]=Forms![ReportOptions]![SelectDivision]")
But it did not work. I know that I'm probably over looking something, but my eyes just can't stare at this screen anymore today.
The following opens up the blank form, but it works....so how can I get the MsgBox to function properly?
=IIF([Forms]![ReportOptions]![SelectDivision] Is Null, "", "[Division]=Forms![ReportOptions]![SelectDivision]")
P.S. I have to stay within my Marco. I don'thave time to code all of the selections and print options
Thanks in advance!