Thank you Vlad, i will take a look. I am slowly learning with the help of you guys on the forumsHi Sam,
The form gets the right value for the HazardID but the second form opens blank because of its record source is not updatable. You don't need all of those tables, just have a look at the update file. Please note that I also deleted the very tiny controls in the upper left, I suggest in the future you just set the Visible Property to No and the background to a color that reminds you that is a hidden control.