password on a form (1 Viewer)

[javier_83]

i use that on the beforeupdate event of the login form, but it doesnt do anything!! what do you think its my mistake??

 

[javier_83]

Something just like (with a wee bit of tweaking) should work.

-dK

wich tweaking do i need?

 

[javier_83]

ok i did it

i use this

Private Sub cmdEnter_Click()
On Error GoTo Err_cmdEnter_Click
Dim rst As DAO.Recordset
Set rst = CurrentDb.TableDefs("historialacceso").OpenRecordset
rst.AddNew
rst!Username = Me.cmbLogin
rst!Fecha = Now()
rst!Hora = Now()
rst.Update
rst.Close
Set rst = Nothing

Exit_cmdEnter_Click:
Exit Sub
Err_cmdEnter_Click:
MsgBox Err.Description
Resume Exit_cmdEnter_Click
End Sub

thanks dk as always!!