Search results

I see what you mean. This does remove the second input screen, but it takes me back a step. When formatting it as "MFP = " & strInput It opens the form to a new record like the filter failed. And as I just typed this response, I believe I figured it out. When searching, I'm searching for...

MFP is a field from the Form that I'm trying to filter by. It is a field with the AutoNumber data type in the form. Do I need to clarify it as a string to use it in the code?

Hello all. My name is Dave and I've been working with/in Access for around 5 years. My introduction started with a great Access DB a colleague created for tracking issues. I appreciated being able to have multiple users have a file open at the same time so I have begun developing Access DB's for...

Reviving this old thread where I'm dealing with the same issue. I created a search button where I'm using an input box to record an input and then opening the form filtered by the search criteria using the where condition in DoCmd.OpenForm Here's the code I currently have for code: Dim...