If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trouble creating a filter
I am trying to create a report to print 3x5 index cards using a select query
filter, I can do this and all three cards are using to be using the paper filter but this creates three duplicate cards. *I am using 8.5x11 card stock for the index card creation(so I don't confuse you).* I am using an option group to show two unbound textboxes and in these boxes will hold a number that will be used to determine which records are to be printed. (ie.. option 2 is active and two boxes are shown and in these boxes are the number 3 and 6 respectively). Herein lies my problem, how do I get the report field to recognize where to put what values. I created 2 select queries (filter1, filter2) to retrieve the values I need referencing the 2 boxes in the current form. Then I created a query (2_indexcard) to retrieve the information from the first 2. All the information is there but is labeled when you run the query as filter1.instruction and filter2.instruction. But when I activate the openreport method it does not recogized the fields in the form. I don't know whether I created the query wrong or I have the control source wrong in the report textbox. Any help would be greatly appreciated. Thanks. |
#2
|
|||
|
|||
Trouble creating a filter
Disregard post, I had my record source associated wrong, thanks for all the
info "default105" wrote: I am trying to create a report to print 3x5 index cards using a select query filter, I can do this and all three cards are using to be using the paper filter but this creates three duplicate cards. *I am using 8.5x11 card stock for the index card creation(so I don't confuse you).* I am using an option group to show two unbound textboxes and in these boxes will hold a number that will be used to determine which records are to be printed. (ie.. option 2 is active and two boxes are shown and in these boxes are the number 3 and 6 respectively). Herein lies my problem, how do I get the report field to recognize where to put what values. I created 2 select queries (filter1, filter2) to retrieve the values I need referencing the 2 boxes in the current form. Then I created a query (2_indexcard) to retrieve the information from the first 2. All the information is there but is labeled when you run the query as filter1.instruction and filter2.instruction. But when I activate the openreport method it does not recogized the fields in the form. I don't know whether I created the query wrong or I have the control source wrong in the report textbox. Any help would be greatly appreciated. Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter | Darhl Thomason | Using Forms | 0 | October 2nd, 2005 03:21 AM |
Trouble when creating secondary axis | menice | Charts and Charting | 0 | November 15th, 2004 04:49 PM |
Need help creating query to filter SQL 7 table by date field | Ivan Starr | General Discussion | 6 | July 14th, 2004 01:53 PM |
Filter Button | Antonio | General Discussion | 4 | June 16th, 2004 05:21 AM |
Determining whther the user is setting or removing the filter... | Brad Pears | Setting Up & Running Reports | 1 | June 9th, 2004 04:29 PM |