Good guess Rain that was exactly what I was doing yesterday, hope you had a win.
I am still having issues with your advice on integrating the forms together into the one frmInspections
I tried a few different ways with no luck
I have successfully managed to use a similar search functionality like in your sample db (probably containing some unneeded code) - however I can't work out how to do anything with the results yet
Back to the main task from what I can see
Ideally frmInspections would be able to edit and add Inspections as well as use a similar search method to search for equipment for the inspection then the user can select the equipment which will show the checklist values that they can verify or fill out and then populate the tblResults (I think)
I will be working on this again for much of the day however feeling the effects of yesterday a bit so hard to say how productive I will be
Thanks
Attachment 5008