Search results

I have an access database with several queries based on tables. Tables contain names of products and product code numbers associated with companies that manufacture them. However now if I add a new product code to the table the search by product code does not give the desired results. It...