Trouble creating a filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top