Originally Posted by
jscriptor09
Hi folks
I have a form that holds 'activity' data. There are about 5000 'activities' in the table.
In a separate table, I have a comment field. Bascially, it allows the user to associate a comment related to a specific activity with the activity. A unique key ties the two tables when I need to run a query.
Not every activity has a comment entry. Some do and some don't
In the activity form, I added the small comment table as a subform. I use the o_Current event to make sure that when the user navigate from one activity to the other, the subform and the activity form stay in sync.
to add a new comment related to a specifc case, the user clicks a button on the activity form, a small modal form pops up and the user enter the new comment. On close, the new comment data is written to the comment table along with the unique key. Sometime, I do append only.
Question:
After the user enters the comment in the modal form and hits the OK button, the modal form closes and the comment is written on to the comment table. To see the comment in the current Activity subform, the user must navigate one record forward or backward and then back to the record.
Is there a way to refresh the Comment subform iside the Activity form with the new comment info as soon as the user clicks the OK button on modal comment entry form?
After hours of fighting "Write Conflict Error" I settled on this schema described above. Seems to work fine, but the user would like the new comment entered appear in the main form right away.
Thanks for you help/suggestions.