Datasheet Subform: IsSelected() method

[Peter]

Hello,

I have Access 2000 and have not been successful in finding an answer to the
following:

enable my command buttons on the form when a user clicks on a row in the subform;
highlight the row to make it easier to read/view; and
open another window when the user double-clicks on a row in the subform.

Any help would be appreciated. Thanks.

Peter

 

[Bertrand]

Heres how I do it:

1. In the subforms OnCurrent event handler insert the code that enables the
command buttons e.g. "Me.Parent.MyCommandButton.Enabled = True".

2. Use Conditional Formatting under the Format menu to make the row(s) that
has focus change color.

3. In the subforms DblClick event handler insert code that opens another
form by using DoCmd.Openform in visual basic. You can also use a wizard to
generate the code for you by inserting a button on the form.

/Bertrand