Hello,
I am unable to get a subform on a tab control to update with new data. I'm going to try to give a detailed explanation of the situation, so please bear with the length of this.
The database opens to the main form, on which is a tab control. The first tab is where the users select the file they want to import and then import the data to the database. When the import process is complete, the database automatically switches to the second tab - which is where I'm having my problem.
The second tab is where the database identifies any duplicate records (based on a single ID field) and allows the user to select which record they want to keep in the main table, which they want to discard and which they want to store elsewhere for later analysis (in case they want to keep that data under a different ID). We don't have any control over the data being imported so we're pretty much stuck with what our suppliers give us. Because of that, I don't know how many duplicate records could be in one of the data sets. There may be only two records with the same ID or there could be more. To keep the user confusion to a minimum, I want the subform on this tab to only display one duplicated ID at a time.
So, when the focus moves to this tab, the database determines which IDs are duplcated, picks one of them and displays the records with that ID. The user then indicates what to do with each record (keep, delete, store for later) and clicks on a button to process that ID. After the processing, the code for that button then runs queries to identify another set of duplicate records which I want to replace the previous one in the subform. The queries that find the next duplicate ID and pull the data from the main table (this query is the record source for the subform) update with the new ID and run properly, but I can't get the new data to show up in the subform.
I've tried all manner of refresh, requery and repaint (me.requery, etc. and Forms!mainform!subform.form.requery), but nothing is working. Any assistance will be greatly appreciated.
Thank you.
I am unable to get a subform on a tab control to update with new data. I'm going to try to give a detailed explanation of the situation, so please bear with the length of this.
The database opens to the main form, on which is a tab control. The first tab is where the users select the file they want to import and then import the data to the database. When the import process is complete, the database automatically switches to the second tab - which is where I'm having my problem.
The second tab is where the database identifies any duplicate records (based on a single ID field) and allows the user to select which record they want to keep in the main table, which they want to discard and which they want to store elsewhere for later analysis (in case they want to keep that data under a different ID). We don't have any control over the data being imported so we're pretty much stuck with what our suppliers give us. Because of that, I don't know how many duplicate records could be in one of the data sets. There may be only two records with the same ID or there could be more. To keep the user confusion to a minimum, I want the subform on this tab to only display one duplicated ID at a time.
So, when the focus moves to this tab, the database determines which IDs are duplcated, picks one of them and displays the records with that ID. The user then indicates what to do with each record (keep, delete, store for later) and clicks on a button to process that ID. After the processing, the code for that button then runs queries to identify another set of duplicate records which I want to replace the previous one in the subform. The queries that find the next duplicate ID and pull the data from the main table (this query is the record source for the subform) update with the new ID and run properly, but I can't get the new data to show up in the subform.
I've tried all manner of refresh, requery and repaint (me.requery, etc. and Forms!mainform!subform.form.requery), but nothing is working. Any assistance will be greatly appreciated.
Thank you.
