S
Steve'o
Server = SQL Server 2000 SP3a
Client = Access 2000 SP3 Data Project
I have a form with a subform, after changing data in the subform the main
form does not refresh to display the effects.
(when an item is entered into the child table, a trigger fires to update the
data in a field in the parent table)
The only way I can get the main form to update is with a little vba in the
AfterUpdate event on the subforms control:
form_frm_main_form.requery (also tried repaint and refresh)
The problem with this is it forces the recordset to be reloaded and takes
the user to record number one, not the one they were editing.
To get round this I could dim strPrimaryKey on the AfterUpdate event on the
sub form, which reads in the record number of the main form. Then
form.requery and set the server filter to load the last edited record. The
problem with this is then the user has to click another button if they
actually want to go to the next main record, because a server filter does
not jump to a position, it filters out all records that do not fit the
criteria.
Is there any way I can get the main form and sub forms to sync after an
update, but still remain on the same record, and still allow users to move
forward and back throught the main forms recordset?
In a regular Access .mdb this is not a problem, its only cropped up throught
using .adp's
Many thanks for any help!
Steve.
Client = Access 2000 SP3 Data Project
I have a form with a subform, after changing data in the subform the main
form does not refresh to display the effects.
(when an item is entered into the child table, a trigger fires to update the
data in a field in the parent table)
The only way I can get the main form to update is with a little vba in the
AfterUpdate event on the subforms control:
form_frm_main_form.requery (also tried repaint and refresh)
The problem with this is it forces the recordset to be reloaded and takes
the user to record number one, not the one they were editing.
To get round this I could dim strPrimaryKey on the AfterUpdate event on the
sub form, which reads in the record number of the main form. Then
form.requery and set the server filter to load the last edited record. The
problem with this is then the user has to click another button if they
actually want to go to the next main record, because a server filter does
not jump to a position, it filters out all records that do not fit the
criteria.
Is there any way I can get the main form and sub forms to sync after an
update, but still remain on the same record, and still allow users to move
forward and back throught the main forms recordset?
In a regular Access .mdb this is not a problem, its only cropped up throught
using .adp's
Many thanks for any help!
Steve.