I have a database for parts tracking ... it has the following Tables - tblPartsDatabase, tblReceive, tblUsed. I have forms to Create New Part, Receive (of parts), Usage (of parts). I have 2 query's that SUM the Receive and Usage Tables and a third query that results in the On Hand Quantity Using all the data in the tblPartsDatabase. Now the issue ... I have a form that searches the query based on a number of parameters the user Inputs (7 different unbound search boxes). I am in the testing mode ... I added a new part through the New Part form and everything works. Then I receive a quantity of the new part in ... this works. I run all the queries and the results are correct. Then I do a search for the new part ... the datasheet shows the item but when I run the search using the Part Number it doesn't find the part (it does find others since I used LIKE for the filter). Then if I clear the search the record for new part does not show up in the datasheet list. Basically when I open the search form I have 2226 records ... once I run ANY search record 2226 has been deleted. I'm sure this is some relationship issue that I am missing. The newest part "received" is record 2226 w/ PartNum 9007C52D ... Something I just noticed is that this does not show up in the record bar on the bottom left - 1st screen shot. The second screen shot is after I selected record 2225 and then re-selected record 2226 on the datasheet. The third screen shot is doing a search for 9007C and the results as shown. The fourth screen shot is after resetting the search field and clicking on search again - Record 2226 is gone. If I close the Part Search and reopen it ... the results again are screen shot 1.
I am quite new (a rookie or novice would be superior to me !!) to access and would appreciate any assistance and guidance ... what am I missing !!!