darksniper
Registered User.
- Local time
- Today, 10:34
- Joined
- Sep 4, 2005
- Messages
- 108
hi,
I have the following code:
What happens when I search for something, if the item is not found, at the moment I delete the text string, and click anywhere on the form, the form would always go to the first record.
I have looked around and I have been suggested to remove the last line, but when I remove it, the code doesn't update the form if the record is found.
Is there anything that I can do to resolve this issue.
Thank you!
I have the following code:
Code:
Private Sub uiFindByIDComboBox_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[sdutentId] = " & Str(Nz(Me![uiFindByIDComboBox], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark 'if this line is removed, the code wont work.
End Sub
What happens when I search for something, if the item is not found, at the moment I delete the text string, and click anywhere on the form, the form would always go to the first record.
I have looked around and I have been suggested to remove the last line, but when I remove it, the code doesn't update the form if the record is found.
Is there anything that I can do to resolve this issue.
Thank you!