Datasheet question

[Sandy H]

I have a form that has a data entry section at the top. The subform
underneath shows the rows of data that have been submitted via the data
entry.

The datasheet shows about 20 rows on screen and when data is entered, the
new data deliberately goes to the bottom row of the datasheet. My question
is - without setting focus to the datasheet, how can I make sure the user
can always see their last entry. Eg if they have 40 rows of data, they want
to see the last 20 rather than seeing the first 20. Is this possible? Maybe
something to do with positioning the scroll bars...

Thanks in advance
Sandy

 

[NevilleT]

Hi Sandy
You can set the query to sort descending for the subform. That will show
most recent at the top whatever the order is you use (date, primary key?).
You will probably want to requery the subform after each update on the main
form. Use the after update event to requery the subform.

Neville Turbit
www.projectperfect.com.au

 

[Sandy H]

Hi Neville
Thanks for the suggestion, but we have deliberately got new records being
added to the datasheet at the bottom. The users are recording survey results
from a large cardboard sheet and the datasheet needs to show the data in the
exact entered order.

I managed to solve the problem by using recordsetclone and bookmarks. Works
like a dream.

Thanks
Sandy