Forum Discussion
MRabuse
Oct 06, 2021Copper Contributor
Apply filter prior to circling through recordset and copying to spreadsheet (Access 365 version)
Good morning, I have a form in my access database which filters data from a query to pull up only information with a user entered numerical field. Ultimately, I would like the user to be able t...
MRabuse
Oct 08, 2021Copper Contributor
I made the following update to the code and the filter seems to work:
Set rst = db.OpenRecordset("Select * FROM qryCorresTracking WHERE AppNumber LIKE '" & Me.AppSearch & "*'")