Access 2007 subform events

[sebair]

My main form contains as tab control. The first tab contains nothing but a suform whose ControlSource is a select query. When the form is opened the results of the query are displayed in the subform. It is a thing of beauty.

Here is my question: The subform has only two events (Enter and Exit). How do I tell when the record selection changes. Or which record is actually selected. There are no controls, as such, on the subform. It is just acting as a datasheet.

I need to be able to tell when the user has selected a record and take action elsewhere.

Any help would be greatly appreciated. I have to demo this to management tomorrow!

Thanks.

[Hmu Hein]

Hi sebair,
You could change the subform to display as a continuous form or single form in property sheet
OR
You could add a combo box on your first tab to let the user choose from records in the subform, i.e. the combo box's row source will be the same as your select query.

[Rabbit]

Use the on current event of the subform's form.