Recent content by Trucktern

@Gemma: This solution worked, thank you @Galaxiom: SearchFor Me, [Field].Name, SearchBox.textI was passing the form, the name of the field I wanted to search, and the text inside the searchbox to use as the value to search for. I'm fairly certain the error occurred due to how I was passing...

frmCurr.RecordsetClone.FindFirst chr(34) & [varf] & "=" & valf & chr(34) This code returns "Runtime Error 3001: Invalid Argument". I had tried adding quotes to this code before with similar results before. Dim strFind as String strFind = varf & "=" & valf...

I've recently been rewriting the code for a search function I had, so I don't have to replicate the code on every single form I create, but can call it using a sub on a module. However, I can't get findfirst to work properly. Currently, my code is set up like this...

Hey everyone, I'm currently an intern just getting started with access, which not that many in my department use. I'm currently working on prototyping a proof of concept database for some financial data, and while everything I've done has been simple enough so far I've run into a bit of a...