Acting on an On_Click Event in a Subform in Datasheet View?

[Guest]

I have a form with a subform that is displayed (default) in Datasheet View. I want to open a popup form while the the On_Mouse_Down Event is on, or even On_Click

The subform is a list of Employees and I want to popup a Skills form on that Employee that is chosen by On_Mouse_DOwn or On_Click. I can't seem to get Access(97) to recognize either event while in datasheet view

Thanks in advance

Wil

 

[Marshall Barton]

I have a form with a subform that is displayed (default) in Datasheet View. I want to open a popup form while the the On_Mouse_Down Event is on, or even On_Click.

The subform is a list of Employees and I want to popup a Skills form on that Employee that is chosen by On_Mouse_DOwn or On_Click. I can't seem to get Access(97) to recognize either event while in datasheet view.

I never use sheet view so this may not be 100% on target,
but since you haven't gotten any other ideas I thought I
give it a try.

The events (Mouse_Down?, DoubleClick would probably be
better) occurs on each control, so if you want the user to
be able to click anywhere in the record, you should have an
event procedure for each control (in some cases, there's a
way to use the same code for all controls).

If you want the other form to open only when a user clicks
on the record selector, then you can use the form's event
instead of having an event for each control.