Is there anyway to bring a form up from another form, that displays the exact same record, but without a filter?(so all the records can be searched through)
this answer is really similar to the question prior to this one concerning Bookmarks
Replace FieldName with the name of the Field containing the data you are searching on
Replace FormName with the name of the Form where you make your selection
Replace TextBoxName with the name of the Control that Contains the selection criteria
Private Sub Form_Load()
With Me.RecordsetClone
Me.RecordsetClone.FindFirst "[FieldName] = " & Forms]![FormName].[TextBoxName]
If Not .EOF Then
Me.Bookmark = Me.RecordsetClone.Bookmark
End If
End With
BTW - the previous example was based on the value in the TextBox being a Numeric such as an ID field. If it is a Text Field then you need to add the appropriate delimiters
Me.RecordsetClone.FindFirst "[FieldName] = '" &
Forms]![FormName].[TextBoxName] & "'"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.