Quick view Open Incidents

[Creegfire]

Hello All!

I think this will be a difficult question but im going to ask it anyway. Ive tried several ways to open 2 forms. Ok, ive achieved this one by letting a code to open up the Main menu (like where you can press buttons) and the second one is to open a field with the open incidents of the person that is logged in.

First question:

How can i achieve that the form will open with the employee name and its incidents?

So what i mean if i login with the name Michiel and a password of it that the main menu will start up but ALSO the form start up with MY open incidents and ofcourse when i login underneath someone else that their open incidents will open.

Second question:

How can i create actually this kind of of good form with the open incidents in it? Do i need to create lets say 5 special forms with all of his own name in it? Or can i create query's that are looking to the login form and that the right query will be loaded?

Can someone help me out please? Im getting desperate...

I will update the first post because i think more people will like this idea!?

 

[neileg]

You need to keep your login form open. Then you can use the name from the login as a criterion in your query. Base your incident form on this query.

Suppose your login form is called frmLogin and you have a control on the form called txtUserName. Then the criterion you need is
Forms!frmLogin.txtUserName