I've asked this question befor and searched high and low for a solution but never gotten a working answer.
How can I get a form with a sub data sheet to refresh itself after the table behind the sub data sheet is updated? For example, one control on the sheet re-alphabetizes the records in the sub data sheet table. After doing this the records in the table do re-alphabetize, but I still need to manually requery the displayed sub data sheet by reselecting another control on the form to show the updated data.
It's a small inconvenience, but would save some time and trouble in the field if the sub data sheet records would automatically update on the form each time the table is changed, rather than needing to refresh the form itself manually through one of its controls.
How can I get a form with a sub data sheet to refresh itself after the table behind the sub data sheet is updated? For example, one control on the sheet re-alphabetizes the records in the sub data sheet table. After doing this the records in the table do re-alphabetize, but I still need to manually requery the displayed sub data sheet by reselecting another control on the form to show the updated data.
It's a small inconvenience, but would save some time and trouble in the field if the sub data sheet records would automatically update on the form each time the table is changed, rather than needing to refresh the form itself manually through one of its controls.
