My mdb is fully functional and debugged but I am interested in knowing if there is an alternative approach.
The output is displayed on an unbounded form having 30 groups of controls to display a photo that is linked to every record in the output table. The output table is accessed using recordset. Up to 30 photos will display on the form. If more then 30 photos are available, command controls (w code) can be clicked to display the next 30, previous set, first set, last set. A command control in each control group opens the input form and displays only the one specific record. Each group also has a check box to select certain photos for display.
The output table is updated with a delete query then an append query from another unbound form. The sql for the append query is modified by first selecting one or more controls on the other unbound form. (I created 14 select queries and stored the query name (for the SELECT statement) in a property of the associated control. Another control property stores the control source (for the WHERE clause). The INSERT statement is hard coded for it never changes). A command control is then clicked firing code that creates then strings together the insert, select and where sql into the append query. The delete query then runs, followed by the append query, finally the output form is opened and the photos are displayed.