mtairhead
Registered User.
- Local time
- Today, 05:26
- Joined
- Oct 17, 2003
- Messages
- 138
I've searched the database, and found several similar questions, but none seem to be simple enough for me to do... That's a great way to start out, isn't?
I have a form (Let's say it's called "Data Entry Form"). I also have a report formatted for that form. (Let's say it's called "Data Entry Report")
The user begins browsing the "Data Entry Form." When the user finds the record he/she likes, they wish to print it. I have a macro set up for this purpose...But I don't know how to get any farther. The macro does not work...
Let me say that I don't know the first thing about SQL statements....Or Do.Cmd...Or even where to use them. I only say that, because it is the common answer to similar questions in the archives. If you have a solution using such concepts, please understand that I have no idea what you're talking about (I usually don't anyway
) and that I may benefit from a bit of explanation....
The best case scenario is to be able to use the "Where Condition" on the "Open Report" command. (Both of these terms are from the "Design View" of creating a macro...) Currently my macro looks like this:
1. OpenReport
Report Name: Data Entry Form
View: Print
Filter Name:
Where Condition: Forms![Data Entry Form]![Call Number] = Reports![Data Entry Report]![Call Number]
When I run this, it asks me to define "Forms![Data Entry Form]![Call Number]"
I don’t get it. Didn’t I just tell it that? What’s wrong with my code? Do I have to venture into the scary world of complicated things that I don’t understand…AKA – Real World…
I have a form (Let's say it's called "Data Entry Form"). I also have a report formatted for that form. (Let's say it's called "Data Entry Report")
The user begins browsing the "Data Entry Form." When the user finds the record he/she likes, they wish to print it. I have a macro set up for this purpose...But I don't know how to get any farther. The macro does not work...
Let me say that I don't know the first thing about SQL statements....Or Do.Cmd...Or even where to use them. I only say that, because it is the common answer to similar questions in the archives. If you have a solution using such concepts, please understand that I have no idea what you're talking about (I usually don't anyway
) and that I may benefit from a bit of explanation....The best case scenario is to be able to use the "Where Condition" on the "Open Report" command. (Both of these terms are from the "Design View" of creating a macro...) Currently my macro looks like this:
1. OpenReport
Report Name: Data Entry Form
View: Print
Filter Name:
Where Condition: Forms![Data Entry Form]![Call Number] = Reports![Data Entry Report]![Call Number]
When I run this, it asks me to define "Forms![Data Entry Form]![Call Number]"
I don’t get it. Didn’t I just tell it that? What’s wrong with my code? Do I have to venture into the scary world of complicated things that I don’t understand…AKA – Real World…
