hello guys!
anybody can help me this type of error in Login form. Im using combo box for multiple users
thank you very much.
Run-time error'-2147217865(80040e37)':
The Microsoft Jet database engine cannot fined the input table or query
'login'. Make sure it exists and that its name is spelled correctly.
(error in line 4)
Private Sub Form_Activate()
Set rs = New Recordset
SQL = "SELECT * FROM login "
rs.Open SQL, con, adOpenStatic, adLockOptimistic, adCmdUnknown
If rs.RecordCount <> 0 Then
While Not rs.EOF
cmbUN.AddItem rs.Fields("UserName")
rs.MoveNext
Wend
End If
End Sub