OpenReport Macro (Newbie question)

  • Thread starter K90267000 via AccessMonster.com
  • Start date
K

K90267000 via AccessMonster.com

Hi all, I am a newbie in using ACCESS 2007

On FORM1, I have a text field named TEXT1 and a button COMMAND1.
On REPORT1 I have FIELD1.

My intention:

User enter text into TEXT1, and click COMMAND1, will open REPORT1, showing
FIELD1 matching TEXT1.
I am using the macro build, to create a On Click event on COMMAND1.

Action:OpenReport
Report Name : REPORT1
View : Report
Filter:
Where:[FIELD1]=[Forms]![FORM1]![TEXT1] <<<<<<<<<<<<<<<<< Did not work!
Window Mode : Normal

What works............WHERE: [FIELD1]="John Tan" <<<<<<<<<<<<<<<<<< Works!

Can someone help me out please?
Thanks!
 

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

OpenReport macro 3
Select Text to End of Footnote 9
OpenForm Criteria in Access 2007 12
Requery Form 1
Show a report filtered by text fields of a form 0
Show a report filtered by text fields of a form 5
Basic setting form filter criter from text box 2
include text from form field in includetext field 2

Top