datasheetView

[wxwx]

Hi,



I wrote some code. it works like this:

A record is being viewed from a single form, when the datasheet button is clicked. the same record on the datasheet view is been highlight. this is working very well. but

I want the record is displayed on the top of datashee. now it is just on the position according the datasheet view.

anyone can help me sort this problem?

thank you angain

 

[jgoodman00]

I am not sure of the 'correct' way to do this, but I think something like the following would work:

Create a boolean field in the source table, & ensure all records are set to false.
When the user selects a record & clicks the datasheet view, set the corresponding records field to true.
Sort the resulting datasheet by this column & it should move this value to either the top or bottom of the list.
You will then need to add code to reset its value to false, when the datasheet is closed...




James Goodman