I need to open a DAO recordset in Access that will reflect changes made to the data while the data is being referenced. I currently do not change the data using the recordset, but I do run other processes based on what I find in the record. I need to see those changes as I continue to review the record as additional processes might need to be run based on what was updated. The data come from only one Access table that resides within the same database as the code for the processing.
I have experimented with all of the openrecordset property calls that I thought made sense, but have not come up with the magical combination.
I could rewrite the code, but I am trying to avoid that.