I have created a search function on a form in my database. I am trying to have a user enter a identification number for a table and be able to pull up the record.
The search function only returns a result on certain records that are in the table.
For example both wireNumber AES1234 and CTL1984 are both on my wireInfo Table and all fields on the table are populated for each record.
When I try to search for CTL1984 on my wireCategoryQuery_v3 form, I have no issues getting the record for CTL1984 to pop up.
However when a search for AES1234 doesn't return anything.
The code that I am using to preform the search is
[wireNumber] Like "*" & [Forms]![wireCategoryQuery_v3]![formSearch]
Now at one point I was able to search for AES1234 and it would pull up a record. I think that at that point I had a query that was named wireCategoryQuery_V3 and then I renamed the query wireCatergoyQuery and I was no longer able to search for AES1234 but I could search for any wireNumber that was added after I renamed the query.
Do I need to rebuild my query to be able to search the full table or could I simply change the name back?