By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

Access 2007 subform events

P: 1
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!

Feb 21 '12 #1
Share this Question
Share on Google+
2 Replies

P: 2
Hi sebair,
You could change the subform to display as a continuous form or single form in property sheet
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.
Feb 22 '12 #2

Expert Mod 10K+
P: 12,364
Use the on current event of the subform's form.
Feb 22 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.