Let me preface this with an apology, I’ve been at work way too long and my brain function hovering between a rock and a zombie. If I omitted something or you need further clarification please do not hesitate to ask.
My search function is not working, and I don’t know why, I’m guessing a errant comma or something. Any help would be greatly appreciated. I have one entry from someone with the last name of “Smith”.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Table information is called “SupplyLog”
<o></o>
Search Form with textboxes to type in search criteria is called “SearchForm”
The name/requestor field is called “Qreq1”
<o></o>
When the search button is clicked, the form Printable2005 is opened. The data for this form is a query called “FloorReport”
<o></o>
The criteria for the Requestor field is
<o></o>
I have tried running this both with and without loading/opening the query and the results are the same. Like I said before, I’m guessing my problem lies with the like function, but I’m at a loss.
My search function is not working, and I don’t know why, I’m guessing a errant comma or something. Any help would be greatly appreciated. I have one entry from someone with the last name of “Smith”.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Table information is called “SupplyLog”
<o></o>
Search Form with textboxes to type in search criteria is called “SearchForm”
The name/requestor field is called “Qreq1”
<o></o>
When the search button is clicked, the form Printable2005 is opened. The data for this form is a query called “FloorReport”
<o></o>
The criteria for the Requestor field is
Code:
Like "*" & [forms]![SearchForm].[QReq1] & "*"
I have tried running this both with and without loading/opening the query and the results are the same. Like I said before, I’m guessing my problem lies with the like function, but I’m at a loss.
Last edited: