I just created a login form using the following code. This code works.

But now i want to retrieve the name (gebruikersnaam) and ID (medewerker_ID) of the user that just logged in.

I added the test oledbcommand but how can I retrieve the name.

I have a public variable declared named strUsername.

Code:
myConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strDatabasePath
    Dim cmd As New OleDbCommand("SELECT COUNT(*) FROM tblMEDEWERKER WHERE GebruikersNaam = @UserName AND Wachtwoord = @Password AND GebruikerApplicatie=true", myConnection)

    Dim test As New OleDbCommand("SELECT Achternaam FROM tblMEDEWERKER WHERE GebruikersNaam = @UserName", myConnection)
    
   
    cmd.Parameters.AddWithValue("@UserName", txtUsername.Text)
    cmd.Parameters.AddWithValue("@Password", txtPassword.Text)