Selection Report

[FlawLezZ]

Hello

Am new here so dont flame me plz

Am stuck in access

At the moment am making a form that you must select the username from a dropdown box

Then it will show you the email

then i have a subform with 2 pages
1 page will show you whitch programs the selected user has installed
the other page will show you what right the users has on the network directory`s

Now i want to make a report button

when user is selected
it will show you the report of the selected user and pages instead of showing all users

So

select user

report button
report with the slected user only with the information of installed applications and network right that i got in the subform

thx in advance

 

[macca the hacke]

Build a button that will open the report. The report works off a query that filters for name of person selected in combo box. To pass the name from the combo box to the query put the following into the criteria of the query: [forms]![frm_name]![cmb_name], where [frm_name] is the name of the form that contains the combo box, and [cmb_name] is the name of the combo box.

 

[FlawLezZ]

Thanks a lot, it worked like a charm

 

[MartijnAn]

I have a simular question. But whatabout you have selected 2 or more persons? Then you have to work with a loop function right?

DoI created this, but it doesn't seem to work:

Function Macro1()
Dim sel_vak As CheckBox
For Each [sel_vak] In [Forms]![frmlijstcomplexen]


DoCmd.OpenReport "rptGBBGroepsID", acNormal, "", "[Forms]![frmLijstComplexen]![SelVakje]=True"


Next
End Function