Event on Click

%3CLINGO-SUB%20id%3D%22lingo-sub-1248281%22%20slang%3D%22en-US%22%3EEvent%20on%20Click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1248281%22%20slang%3D%22en-US%22%3EHey%2C%20i%20am%20working%20on%20a%20sports%20manager%20game.%20I%20will%20simulate%20games%20outside%20of%20Access%2C%20but%20store%20data%20(players%2C%20standings%2C%20stats%2C%20rosters%2C%20etc...)%20on%20a%20database.%20I%20am%20trying%20to%20build%20my%20demo%20on%20Access.%20I%20want%20to%20be%20able%20to%20view%20various%20reports%20by%20clicking%20on%20report%20objects.%20As%20an%20example%2C%20i%20want%20to%20open%20a%20team%20roster%20report%20by%20clicking%20on%20the%20team%20name%20on%20the%20standings%20report.%20Or%20to%20view%20a%20player%20profile%20report%20by%20clicking%20on%20his%20name%20from%20the%20roster%20or%20stats%20list.%20I%20have%20tried%20various%20options%20i%20found%20on%20the%20net%2C%20but%20nothing%20works.%20Any%20ideas%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1248281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eevent%20on%20click%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249684%22%20slang%3D%22en-US%22%3ERe%3A%20Event%20on%20Click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249684%22%20slang%3D%22en-US%22%3E%3CP%3EA%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F591973%22%20target%3D%22_blank%22%3E%40NickMen%3C%2FA%3E%26nbsp%3BAt%20this%20level%20of%20generality%20(an%20overview%20of%20the%20goals)%20it's%20really%20not%20possible%20to%20respond%20with%20anything%20but%20generalities.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThat%20said%2C%20if%20you%20want%20to%20open%20a%20report%20by%20clicking%20on%20a%20control%20on%20another%20report%2C%20you%20will%20have%20to%20open%20that%20first%20report%20in%20%22REPORT%22%20view.%20Opening%20a%20report%20in%20%22PRINT%20PREVIEW%22%20does%20not%20allow%20any%20actions%20to%20be%20initiated%20on%20that%20view.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlace%20your%20code%20to%20open%20the%20second%20report%20in%20the%20label%20or%20text%20box%20control%20for%20the%20team%20name%20on%20the%20launching%20report.%20Open%20that%20launching%20report%20in%20Report%20view.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor
Hey, i am working on a sports manager game. I will simulate games outside of Access, but store data (players, standings, stats, rosters, etc...) on a database. I am trying to build my demo on Access. I want to be able to view various reports by clicking on report objects. As an example, i want to open a team roster report by clicking on the team name on the standings report. Or to view a player profile report by clicking on his name from the roster or stats list. I have tried various options i found on the net, but nothing works. Any ideas?
1 Reply
Highlighted

A@NickMen At this level of generality (an overview of the goals) it's really not possible to respond with anything but generalities. 


That said, if you want to open a report by clicking on a control on another report, you will have to open that first report in "REPORT" view. Opening a report in "PRINT PREVIEW" does not allow any actions to be initiated on that view. 

 

Place your code to open the second report in the label or text box control for the team name on the launching report. Open that launching report in Report view.