Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Report help 2

Status
Not open for further replies.

ankrunner

Programmer
Jul 22, 2007
1
0
0
US
I am trying to create an access report which only displays the name of an author of a publication. I created a database for publications and presentations within my dept. The problem is some publications have multiple authors. I want to create a get report button which you indicate an author name and the report will only display that author's publications. Any ideas?

-Lori
 
In the report's OnOpen event you could set its .Filter to "AuthorName like '*" & [SelectedAuthorName] & "*'".
 
FYI there is an Access Report forum that may provide more answers (FAQs)...

I wondered why the baseball was getting bigger.
Then it hit me.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top