Criteria Form

  • Thread starter Thread starter D Collins
  • Start date Start date
D

D Collins

Hello,
I created a form with which I wish to capture the
criteria for a report. I have a main report /
subreport. They are linked by an ID Number. The
subreport, let's say has many transaction entries by
date.

Here's the problem: I used the reference to the unbound
textbox on the form, but where do I place it? I put it
as criteria in the subreport's underlying record source,
but as I navigate to each page, the parameter keeps
popping up. How do I make it so that what I choose on
the form a specific transaction date, for example. I
would like to show all records for that transaction date?

I hope this makes sense. Thanks.
D.
 
Sounds like you created a parameter in the query that feeds the subreport?

Instead of a parameter, you can use a reference to the text box on your
form. The Criteria row under this field would look like:
[Forms]![MyForm]![MyTextbox]
where "MyForm" is the name of your form, and "MyTextbox" is the name of your
textbox. Provided the form has not been closed and the text box contains a
valid date, you should not see any parameter box popping up.
 
Hi,

I did use the reference to the box on the form, but it
keeps popping up at each page I navigate to on the
report. Is it because the criteria is in the subreport
and not the main report?

D.
-----Original Message-----
Sounds like you created a parameter in the query that feeds the subreport?

Instead of a parameter, you can use a reference to the text box on your
form. The Criteria row under this field would look like:
[Forms]![MyForm]![MyTextbox]
where "MyForm" is the name of your form, and "MyTextbox" is the name of your
textbox. Provided the form has not been closed and the text box contains a
valid date, you should not see any parameter box popping up.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
Hello,
I created a form with which I wish to capture the
criteria for a report. I have a main report /
subreport. They are linked by an ID Number. The
subreport, let's say has many transaction entries by
date.

Here's the problem: I used the reference to the unbound
textbox on the form, but where do I place it? I put it
as criteria in the subreport's underlying record source,
but as I navigate to each page, the parameter keeps
popping up. How do I make it so that what I choose on
the form a specific transaction date, for example. I
would like to show all records for that transaction date?

I hope this makes sense. Thanks.
D.
Click to expand...


.
Click to expand...
 
Back
Top