Datasheet Subform: IsSelected() method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...

Any help would be appreciated. Thanks.

Peter
 
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
 
Back
Top