Attached is a database that I have been working on for far too long. I am new to access, but my current job has my doing a revamp on their calibration database. In 'Calibrate' I have the search, reset, and print report working well. I am having trouble with 'Add Instrument'. At the beginning I had everything working perfect, except nothing was updating and I realized the my source was a table and not a query. So I have since changed the source to 'SearchQuery', but now I can get some things to update, such at 'NextCalDate', but I can't get 'Department ID' or 'Department' to work well anymore. Any help with this would be amazing.
NewestTest2.mdb1.zip