Search results

That part of the query was something that I added through the expression builder. I've since removed it but it was still working despite that part, it was in the "Expression Values" box. Thanks again for all your help.

I tryed that query as well with no luck. I ended up getting it to work, I selected the Compact & Repair db option and its now returning values. Not exactly sure why that changes things. Thanks everyone for your help though. Much appreciated.

I should also add, this is an ODBC db table I'm searching off of.

Yes, I believe I've drilled down the problem to it being something in the way I'm querying the data. I followed the instructions in the video posted and I'm able to get the form commands working as intended now, the only problem now is I keep I getting blank results when I shouldnt. Heres my...

Yes exactly. It almost seems like when I click the button to run the query, it thinks the text box is empty, but when I click the bottom of the form, it somehow reads whats in the text box and runs the query as intended. Is there some sort of event I have turned on?

I ended up at least figuring out why that original error was occuring. Turns out I had some random VB code in my DB that was causing it to misread something. But now I'm having another error. I assigned an action to the button that essentially runs the query when pressed, BUT.. It returns a...

Thanks for the response, I tryed the Dlookup function and it still doesnt seem to be able to find the text I entered in the unbound text box since it basically gives me the same message to enter a parameter value.

I have an unbound text box on a form I created titled frmDS_BULK_DATA_VALIDATION, the unbound text box is titled Text7. I'm trying to create a simple query which populates whatever is entered in the unbound text box within a field on the query titled ISS_ID. So I used the expression builder to...