N
Nick
I have a datasheet sub form with a checkbox called Select,
for each record returned in the sub form. Once I have
selected the required record by checking the box I can
then press a button to preview a report of the selected
records.
However the last record I select is not displayed. So to
over come this I set up a requery on click, as follows;
Private Sub Select_Enter()
Me![Child2].Requery
End Sub
The problem that each time I check a record and the
requery happens the curser moves back to the first record
in the list.
My question is how can I still have the requery but retain
the curser at the last selected record?
Any help appreciated.
Nick
for each record returned in the sub form. Once I have
selected the required record by checking the box I can
then press a button to preview a report of the selected
records.
However the last record I select is not displayed. So to
over come this I set up a requery on click, as follows;
Private Sub Select_Enter()
Me![Child2].Requery
End Sub
The problem that each time I check a record and the
requery happens the curser moves back to the first record
in the list.
My question is how can I still have the requery but retain
the curser at the last selected record?
Any help appreciated.
Nick