M
M Skabialka
I created a form with a subform showing multiple records in continuous form
view. By clicking or double clicking on one of these records the user is
taken to another form where lots of information is entered about the record.
When that form closes I requery the subform to update one field;
TotalRemoved. However the focus then moves away from the highlighted record
on the subform to the top one, when our users would like to continue
selecting items further down and have to scroll as many as 50 records down
to get back to where they were. I have separated the records into groups
and am using tabs to make the lists shorter.
The updated field is: forms!frmItemRemoved![frmItemRemoved
subform6].Form![TotalRemoved] and is updated each time the user clicks and
adds information on the other form. There are 10 tabs, so 10 instances of
the subform. The other fields that show on this subform do not change -
they just identify the item so the user can select it.
The Tab name is obtained from
forms!frmItemRemoved!MajorGroup.Pages(forms!frmItemRemoved!MajorGroup.Value).[Name]
How can I keep the focus on the selected record on the subform, or return to
it after the requery?
I think I need to use a GoToControl and a FindRecord but have been unable to
make it work using multiple subforms on tabs. Each record has an
ItemRemovedID.
Thanks,
Mich
view. By clicking or double clicking on one of these records the user is
taken to another form where lots of information is entered about the record.
When that form closes I requery the subform to update one field;
TotalRemoved. However the focus then moves away from the highlighted record
on the subform to the top one, when our users would like to continue
selecting items further down and have to scroll as many as 50 records down
to get back to where they were. I have separated the records into groups
and am using tabs to make the lists shorter.
The updated field is: forms!frmItemRemoved![frmItemRemoved
subform6].Form![TotalRemoved] and is updated each time the user clicks and
adds information on the other form. There are 10 tabs, so 10 instances of
the subform. The other fields that show on this subform do not change -
they just identify the item so the user can select it.
The Tab name is obtained from
forms!frmItemRemoved!MajorGroup.Pages(forms!frmItemRemoved!MajorGroup.Value).[Name]
How can I keep the focus on the selected record on the subform, or return to
it after the requery?
I think I need to use a GoToControl and a FindRecord but have been unable to
make it work using multiple subforms on tabs. Each record has an
ItemRemovedID.
Thanks,
Mich