D
dmcheng1
Hi. I have an Access 2002 ADP project connecting to a SQL 2000
database. I have a form "Main" using a stored proc as a record source.
I have a continuous subform "Sub" using a Select statement as a record
source.
In Sub's AfterUpdate event, I run a stored proc to update data in a
table and then I Refresh the Main form to display the updated data.
This event works fine if I am adding or editing records in Sub.
However, if I delete records in Sub, then the Main form does not
display the updated data - I have to exit the form and re-enter it in
order to see it.
Anyone know why this occurs? I've tried putting the refresh code in
Sub's Delete event, but that doesn't work either.
Thanks
David
database. I have a form "Main" using a stored proc as a record source.
I have a continuous subform "Sub" using a Select statement as a record
source.
In Sub's AfterUpdate event, I run a stored proc to update data in a
table and then I Refresh the Main form to display the updated data.
This event works fine if I am adding or editing records in Sub.
However, if I delete records in Sub, then the Main form does not
display the updated data - I have to exit the form and re-enter it in
order to see it.
Anyone know why this occurs? I've tried putting the refresh code in
Sub's Delete event, but that doesn't work either.
Thanks
David