I setup a table with All of the different fields we need to keep track of maintenance in access, and setup various forms depending on what piece of machinery the maintenance is being done on. The problem I'm having is getting the form to load or keep track of the data. I'm not very familiar with Access, so it could be a simple mistake. I made the ID field in the database Date/Time... I figured since I'm keeping track by date, this would be OK. When I select the first form and check what we've done maintenance on, everything works fine. If I open another form, select the same date in the ID field, it does not load the same record though and does not track the data I entered.
Anyone know what I'm doing wrong?