Show The Last 10 Records entered on Form

[athyeh]

Hi Folks,

I have created a form that multiple processors are using at the same time (Split Front End) to track production in a database. They do this by scanning in barcodes with a scanning wand. Now to help eliminate double-scans and scanning error I have put a subform onto the data-entry form that shows all the records the operator has scanned into the table.

This was great until 20+ people started using it, and the subform shows every single record the operator has ever scanned in and generally just lags the scanning form down to being unusable.



Is there a way to create the same type of thing?

Ultimately, I want the processor to be able to see and edit the last 10 records they entered on the data-entry form.

thanks,

Tony

[June7]

Is this a split database?

I have a form with a subform that lists about 19,000 records and no noticeable lag. I have another form with a subform listing about 67,000 records and that one does show a little delay.

You could try a query using the TOP n parameter.

[John_G]

Hi -

If the individual operators need to see only their own data, and there is no particular reason why records have to be added to the main (Back-end) database in real-time, you could have each operators entries kept in their own front-end file, and periodically uploaded to the back-end database. In its simplest form, that could be done using an append query to upload, and a delete query to delete the local (temporary) data.

HTH

John