Bringing up a form from within a form, without the filter mode

[helphelpme]

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)

 

[PaulF]

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

PaulF

 

[PaulF]

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] & "'"

PaulF