Show a report filtered by text fields of a form

  • Thread starter bladu via AccessMonster.com
  • Start date
B

bladu via AccessMonster.com

Hi,

I have a report which I want to filter depending of the values of two field
text of a form.

For that reason I have created a macro using the command OpenReport, where
in the filter condition field I have put:

[Name of the report field1]=[Forms]![FormName]![Name of the form field1]
AND [Name of the report field2]=[Forms]![FormName]![Name of the form field2]

But It doesnt run because, when I try to execute; it appears to me 2 text
boxs asking about these two field values.

I would be grateful if somebody could help me to solve this problem

Regards

Jose
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show a report filtered by text fields of a form 5
Setting OrderBy for a report in VBA 2
Split form 0
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Summary Report 2
Tab-like output in a text field 2
Record Source not showing field names 4

Top