Open form for corresponding combobox selection

[ashok srmuniv]

Hi,
I have database with two forms(Login form & Info form) and a table. When I login with a user name , it has to open the "Info form" with the corresponding username's record. Please help me to fix this. Below this the code what I have now. Thank you

  'Open "Info_form" and pass the User_Name in OpenArgs parameter
        DoCmd.OpenForm "Info_form", , , , , , Me.User_name
       Forms("Info_Form").Button1.Visible = (Me.User_name = "Admin")
        DoCmd.Close acForm, Me.Name

[Malathi]

You are opening the form and passing the username. But you are not opening the recordset of the paricular user in the form and also not passing the values. I think this might be the point!

[ashok srmuniv]

Hi malathi,
yes . what I have rite now is this. How and where to include the code to open the corresponding recordset.

[Mihail]

Try this:

DoCmd.OpenForm "Info_form", , , "UserName = " & Me.User_name, , , Me.User_name

If don't work, post the implied tables structures.

PS:
Edit your preview post (click Edit button)
Select this text:
'Open "Info_form" and pass the User_Name in OpenArgs parameter
DoCmd.OpenForm "Info_form" , , , , , , Me.User_name
Forms("Info_For m").Button1.Vis ible = (Me.User_name = "Admin")
DoCmd.Close acForm, Me.Name
Click the <CODE/> button, in order to appear like this:

'Open "Info_form" and pass the User_Name in OpenArgs parameter
DoCmd.OpenForm "Info_form", , , , , , Me.User_name
Forms("Info_Form").Button1.Visible = (Me.User_name = "Admin")
DoCmd.Close acForm, Me.Name

Do that from now when you post code !

Cheers !

[ashok srmuniv]

Hi Mihail,
This is not workin. let me show you some other code.I have a drop down in the Infoform for admin,where he can view all the users through a drop down.I want something similar like this when a user login it should show their form.

User_ID = Me.NName.Value
DoCmd.SearchFor Record , "", acFirst, "[User ID] = " & "'" & Screen.ActiveCo ntrol & "'"

[ashok srmuniv]

so the username comes from "User ID" and when the form opened by a user , it shold show up only his own record.
Please help me on this