Hello very smart people,
I have the following code:
It previously worked then all of sudden when I open the form, it gives me Error 94 Invalid use of Null on the Me.LstUser.AddItem rs("UserLogin") Step.
What am I missing here? :banghead::banghead:
Thank you
I have the following code:
Code:
Option Compare Database
Option Explicit
Dim db As DAO.Database
Dim rs As Recordset
Private Sub Form_Load()
Set db = CurrentDb
Set rs = db.OpenRecordset("Qry_User", dbOpenDynaset, dbSeeChanges)
Do Until rs.EOF
Me.LstUser.AddItem rs("UserLogin")
rs.MoveNext
Loop
End Sub
What am I missing here? :banghead::banghead:
Thank you
Last edited by a moderator: