I have a main form for Staff displaying all personal data. The underlying table for the main form is 'tbl_Staff'. I created a query, 'qry_Staff_TotalFTE', that summarizes data from a second table. I wanted to loop through the query results and update the TotalFTE in 'tbl_Staff' with the 'TotalFTE' from the query 'qry_Staff_TotalFTE' where the UTIDs match.
I want to create a button on the main form, 'Update All FTEs", so when pressed it will loop through the query and at the same time give a visual of where the process is. For example a text box on the main form that shows what UTID is being processed at the time. I put the text on the form already, named "txtLoopingUTID".
I hope this makes sense.