mtairhead
Registered User.
- Local time
- Today, 06:53
- Joined
- Oct 17, 2003
- Messages
- 138
I've seen this question before on this forum, but I don't understand the answer....
Can I user the "Where Condition" in the "Open Report" command (Both found when creating a macro in design view...) to have the current record that is currently being viewed on a form to be the only record printed/viewed on a report.... So far, the macro looks like this:
1. Open Report
Report Name: Data Entry
View: Print
Filter Name:
Where Condition:Forms![Data Entry]![Call Number] = Reports![Data Entry]![Call Number]
Currently, when I run this macro, it gives me a dialog box with the title: "Enter Parameter Value" and gives me: "Forms!Data Entry!Call Number"
After I enter in a number there, I must do the same for the report. Why isn't this working? I know the names are correct because I used the expression builder.
Can I user the "Where Condition" in the "Open Report" command (Both found when creating a macro in design view...) to have the current record that is currently being viewed on a form to be the only record printed/viewed on a report.... So far, the macro looks like this:
1. Open Report
Report Name: Data Entry
View: Print
Filter Name:
Where Condition:Forms![Data Entry]![Call Number] = Reports![Data Entry]![Call Number]
Currently, when I run this macro, it gives me a dialog box with the title: "Enter Parameter Value" and gives me: "Forms!Data Entry!Call Number"
After I enter in a number there, I must do the same for the report. Why isn't this working? I know the names are correct because I used the expression builder.
