Jamesharks 0 Newbie Poster

I have 2 forms; one called frmLogin and another called user_info.

On frmLogin I have a text box called USERNAME and a command button. When you click the command button the following code is run:

This Code Works (Or atleast It should)

Private Sub Command29_Click()
    Dim strUSERNAME As String
    Dim strProcess As String
    
    strUSERNAME = Me.USERNAME
    strProcess = LOGIN(strUSERNAME)
End Sub

The code takes what has been typed into to the textbox USERNAME and passess it onto the module LOGIN which has the following code:

This Code Does NotWork

Public Function LOGIN(strLOGIN As String)
    
    DoCmd.OpenForm "user_info"
    DoCmd.FindRecord strLOGIN
    
End Function

I know this code does not work but I don't know what to do to get it working. I am trying to get it to open the form user_info and display records relating to what has been typed into the textbox USERNAME.

If you have any suggestions please reply.

Thankyou

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.