Search (Filter) button on main form to also get proper records on subform

[isladogs]

That is correct so it should work. Maybe I will try Microsoft Support to see it they can figure it out. Microsoft has said that you can not install 32 bit Access and have 64 bit Microsoft 365 on the same computer.

Although not advised, it is often possible to run both 32-bit and 64-bit on the same workstation. See Installing Multiple Office Versions (isladogs.co.uk).


I'm not recommending that approach but it can be done in certain cases. Or use a VM
.
There is nothing wrong with 64-bit Access. For many purposes, either bitness is fine though you will need to make some code changes in 64-bit if you use APIs
However, 64-bit does have some advantages as it has better memory management. This means certain demanding tasks will run faster and significantly reduce the risk of crashes

Nevertheless, the parameter prompts are nothing to do with the bitness used

[Welshgasman]

Had a look in the Documenter.

[PlayerPianoMan]

I'm new to this form so I have a simple question. How do I mark this as solved?

[June7]

Thread Tools dropdown at top of first post. Done.

[moke123]

I'm a little late to the game but thought I'd throw this out there anyway.

Have you considered .FindFirst rather than a filter?

Private Sub btnSearchCatNumber_Click()

    Dim rs As DAO.Recordset
    Dim strCatNumber As String
     
     Set rs = Me.RecordsetClone
    
    strCatNumber = InputBox("Enter Catalog Number", "Catalog Number", TitleNumber)
     
    With rs
    
        .FindFirst "TitleNumber = """ & strCatNumber & """"
     
        If Not rs.NoMatch Then
            Me.Bookmark = rs.Bookmark
        Else
            MsgBox "Title Number Not Found"
        End If
        
    End With

End Sub