Despertly needing code

[michayla]

Hi everyone, if any one can help me out with the following coding problem I would greatly appreciate it. Here is the scenario.
The form that I have set up has a password - I have five of them actually.
Each member of our company has a password protected form
5 Forms - 5 Users
Now here is the problem that I am having - when they sign in they bring up the appropriate form (this is not the problem), I also need them to pull up the proper report for their department(this is the problem). What code should I use with this.

Thank you in advance
Michayla


[This message has been edited by michayla (edited 05-09-2002).]

 

[doulostheou]

Each user has their own form? And each user has a different report you need opened? Do you want the report to open automatically when they go into the form or will it be opened from a button? If I'm misunderstanding your post, this will most certainly be too simplistic. Whether its onClick of a button or onOpen of the form, you just need to type:

DoCmd.OpenReport "AppropriateReportName", acViewPreview

If everyone already has a separate form, just change the report name to the appropriate department's report.