I am trying to write a simple database program. My problem is when one of the forms loads I get a run time error 91. Here is a copy of the code from this form. Debug highlights my error at UserInfo.Recordset.AddNew. I tried removing that line of code and get the same error code, only then it points to UserInfo.Recordset.Fields("username") = txtName.Text. I have a connection to the DB "UserInfo" and the field names are correct. Any help would be greatly appreciated.
Private Sub cmdClear_Click()
txtName.Text = ""
txtPassword.Text = ""
Private Sub cmdConfirm_Click()
UserInfo.Recordset.Fields("username") = txtName.Text
UserInfo.Recordset.Fields("password") = txtPassword.Text
Private Sub Form_Load()
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.