Correct way to pass some fields to another form
First let me say I am new to databases and I will usually research my questions thoroughly before asking the question as I feel that is the best way to learn. With that said,
I have a form that will open another form when certain conditions are met. When the new form opens I want some fields to pass to the new form, but there will not always be the second form. Example, Inspection log of manufactured parts, 10 items pass fine and then an items fails. When it fails the user will check the reason for failure in the inspection log and upon exiting that field a new Defect Note form will open forcing the user to complete a defect note. Any help would be greatly appreciated.