Datasheet View - Customize
I have an application that requires complete control over a subform in datasheet view. Here are a couple of items I'm having a hard time implementing. My first thought was to use a list box control, but I need the power of moving columns, sorting and filtering that the subform allows. The data is not editable.
If possible, I would like to limit the user to only selecting a single record at a time.
The recordsource is based on an ADO recordset extracted via a SQL Server stored procedure and there seems to be some issues with using the bookmark property of the form object after the form is set to the ADO recordset. Here is what I'm trying to accomplish. If there are 1000 records in the subform and I scroll down to record 587 and delete it, when the form is requeried, I can't find a way to return focus to record 586. I've tried the bookmark property, absoluteposition, currentrecord(form object), percentposition. Any ideas?
I would like to simulate the highlighting of a single row when the user moves the focus to a different row...just like in a list box. If you click in a field, press F2 and then Shift+space, the row will highlight. I tried using sendkeys in various events, but the end results were never correct.