I had a form that has a combo box that I could open and click on a member whose data I need to change. This form worked perfectly until after an automatic "Office" update occurred. Now the form returns the name in the combo box but does not fill in the form such that I can make needed changes. I can cycle through all the names until I find the name I need to change, but that is a pain in the a**. What happened?
The code used is where "qname" is the name of the unbound combo box which when I click on it should return the form with all the data on it. I tried the system restore. This did not cure the problem.
Private Sub qname_AfterUpdate()
Dim MyName As DAO.Recordset
Set MyName = Me.RecordsetClone
MyName.FindFirst "[LastName] = '" & Me.qname & "'"
If MyName.NoMatch Then
MsgBox "Name Not Found"
Else
Me.Bookmark = MyName.Bookmark
End If
End Sub