This is a problem I have in several applications.
From button on a form, I open another form, like this:
DoCmd.OpenForm "Form2", , , , , acDialog
Form2 presents a list of records. The user selects a record then clicks an OK button. The logic on the OK button gets the selected record's ID and...