Have a form that has controls to lock the form and unlock the form for editing records. however, the list box on this form needs to be unlocked at all times and searchable. If I put this list box on a subform tied to the main form will this keep it from being locked when the CMD button is clicked? Also using this code for the list box, Private Sub Combo105_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Nz(Me![Combo105], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
What would need to change in order for this to work on the subform?
If anyone has any other ideas on how to do this quicker, better faster, please feel free to comment.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Nz(Me![Combo105], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
What would need to change in order for this to work on the subform?
If anyone has any other ideas on how to do this quicker, better faster, please feel free to comment.